How can I pivot a pivot table? I want to create a pivot table using another pivot table as it’s source.
To pivot a pivot table in Row Zero, simply right-click on your pivot table and select Pivot to create a new pivot table using your current pivot table as it’s source.
All columns from your first pivot table are now available as fields in your second pivot table and your second pivot table will update in sync with your source pivot table and source data as you make changes.
Here’s more info on how to create a pivot table from a pivot table and a video tutorial:
