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

Customize an Excel Slicer  Excel Slicers are very boring looking and there are only 14 different Slicer Styles to choose from, ranging from Light to Dark and with a few colors to choose from.What if you wanted to create your own Slicer using your creative mind with super cool colors and f...
Classic Pivot Table Layout View For all of you old schoolers out there who used to use the drag and drop Pivot Table option in Excel 2003 or prior, well you still have that option in Excel 2010 and onwards.To activate this option you need to Right Click in your Pivot Table and choose Pivot Table Options. ...
Color Scales in a Pivot Table Color Scales are new in Excel 2010 and they highlight the smallest and largest data points within your Pivot Table.It works like a heat map, in that it gives the highest number a shade of color and the lowest number a different shade of color, so your numbers can stand out at...
Add Custom Symbols With Your Numbers in Excel A cool feature within Excel is the ability to format a cell's value by pressing CTRL + 1 on any cell.This brings up the Format Cells dialogue box and under the Custom category you can customize the Type to whatever you like and even insert symbols!There are four formattin...