Please allow functionality to turn pivot table to basic spreadsheet.
It would be very flexible to be able to deconstruct pivot table into basic worksheet. This should break the connection and all pivot table propertiies. Of course it would be irreversible.
double-clicking the grand-total value the pivot table created a new sheet with all the details that the grand-total was based upon
Thant's what I was looking for but couldn't find solution/steps anywhere.
If you double-click the grand-total value the pivot table will create a new sheet with all the details that the grand-total was based upon. Isn't that the "basic worksheet" that you want to achieve?