When you are using an Excel Pivot Table you can show the items within the Report Filter on separate sheets inside your workbook.

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.


Here is our pivot table:


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


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


STEP 3: Press  OK.

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

Report Filter on Multiple Pages



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Format Error Values in a Pivot Table Whenever you do a calculation in an Excel Pivot Table you may get an error value like a #DIV/0! This looks ugly when you are presenting important information.  Luckily you can override this with a custom value or text. To activate this you need to Right Click in any Value i...
Pivot Table Number Formatting You can easily format your Pivot Table values simply by Right Clicking on a value and choosing Number Format.  Then you can choose from the many different formats, like Number, Currency, Percentage or Custom. DOWNLOAD EXCEL WORKBOOK   STEP 1: Right click in the Pi...
Filter a Pivot Table by Dates There are an array of different Date filters in a Pivot Table.  You can filter by a particular date range, for example: by this week, next month, next quarter, next year, last year, year to date and the list goes on and on.  This is useful if you want to see what invoices are due...
Logarithmic Scale In An Excel Chart When you have a large numerical range of data and you want to plot a graph, you will most probable end up with a skewed looking chart like the one below: You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10. W...