Pivot Filter Pages
By Wyn Hopkins
A little known but very useful functionality in pivot tables is the ability to automatically create a new sheet for each item in a filter.
For example, if you have a pivot table showing the monthly results for all Cost Centres, you can very easily create a separate sheet for each cost centre.
Step 1: Ensure your Pivot Table has something in the Report Filter Box (in this example I’ve used Cost Centre)
Step 2: Click anywhere in the Pivot Table, then in the Pivot Table Ribbon that appears select Options > Show Report Filter Pages
Done! Yes it’s that simple, you now have a separate sheet for each cost centre