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