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)

Pivot Filter 1 Resized(3)

Step 2: Click anywhere in the Pivot Table, then in the Pivot Table Ribbon that appears select Options > Show Report Filter Pages

Pivot Filter 2 Resized Larger

Done!  Yes it’s that simple,  you now have a separate sheet for each cost centre

Pivot Filter 3 Resized Larger