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.

DOWNLOAD EXCEL WORKBOOK

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

HELPFUL RESOURCE:

hmb_logo_01Lg

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count. This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit. DOWNLOAD...
Show The Difference From Previous Years With Excel... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation. You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...
Show the Difference From Previous Month with Direc... Using a Pivot Table you can show the variance from your previous month's sales very easily... See how to Show The Difference From Previous Months With Excel Pivot Tables here Now that we have the Pivot Table report above, we can show the variances per month using an up/...
Lock the Excel Pivot Table but not the Slicer Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format. What you can do is lock the Pivot Table and only allow the user(s) to select the Slicers, making your report interact...