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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button.The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Drill Down To Audit Using a Pivot Table When you are using a Pivot Table in Excel and want to know what data makes up a certain value, all you have to do is double click on that cell.This will open up a brand new Sheet with all the rows of data that make up that value.NB. This is an extraction of your data sour...
Pivot Table Filter: Top 5 Customers You can easily Filter your Pivot Table to show your Top X customers.  There are lots of different Value Filters to choose from and one of my favorites is the Top 10 Filter.DOWNLOAD EXCEL WORKBOOKHere is our pivot table: STEP 1: Go to Row Labels > Val...
Add Columns to Pivot Table Slicer Buttons When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout.Say that your Pivot Table Slicer is showing months from January to December.  You can change the layout of the buttons to show in 3 separate column...