Pinterest Pixel

Show Report Filter Pages in a Pivot Table

John Michaloudis
When you are using an Excel Pivot Table you can show the items within the Report Filter on separate sheets inside your workbook.
Show Report Filter Pages in a Pivot Table | MyExcelOnline Show Report Filter Pages in a Pivot Table | MyExcelOnline

Say that you have created an awesome Pivot Table which shows total sales and number of transactions per region.

You can drop in your Customer field in the Report Filter and replicate the Pivot Table for each of your customers in a separate Sheet.

All you need to do is click inside your Pivot Table and in the menu ribbon under PivotTable Tools choose the Options tab and then select the Options drop down and choose Show Report Filter Pages.

Each of your customers will have their unique Pivot Table in a separate Sheet with their individual sales and transactional metrics.

Show Report Filter Pages in a Pivot Table | MyExcelOnline

Download excel workbookReport-Filter-on-Multiple-Pages.xlsx

Here is our pivot table:

Show Report Filter Pages in a Pivot Table

 

STEP 1: Drop the Customer Field in the report filter.

Show Report Filter Pages in a Pivot Table

 

STEP 2: Go to Options > Options Drop Down > Show Report Filter Pages

Show Report Filter Pages in a Pivot Table

 

STEP 3: Press  OK.

Show Report Filter Pages in a Pivot Table

Each customer’s pivot table will show in a unique sheet!

Show Report Filter Pages in a Pivot Table

Show Report Filter Pages in a Pivot Table

 

MATCH Function Intro

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Logarithmic Scale In An Excel Chart

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...