Create Multiple Reports From One Pivot Table


This tip is one my most favorite time savers when using Pivot Tables- the ability to create many reports with just a few mouse clicks.

The scenario for this example is the national sales manager want to meet with all regional sales managers and look at their year to date sales. We have extracted the data from our database and have saved it in .xlsx format.

We have created the the Pivot Table and the national sales manager can easily interactively change the filter on the table to focus on the individual regional managers figures.
All good yes?. But the national sales mangers really want each regional manger to have their own report. But that is not a problem!

Create your usual Pivot Table and Region to the report filter.

Multiple Reports From One Pivot_1

 

 

 

 

 

 

 

 

 

 

 

 

All we need to do then is hit

  • Pivot Table Tools
  • Pivot Table
  • Options
  • Show Report Filter Pages

We have one Filter in this Pivot table ….

Multiple Reports From One Pivot_2

 

 

 

 

Multiple Reports From One Pivot_3 Select it and then hit Ok.

You will see see all of the Regions now appear in different sheets in your Excel workbook automatically, your national sales ,manager now has all of the reports they need individually to discuss with the regional sales managers.

 

 

Job Done!

 

Multiple Reports From One Pivot_4

 

More Excel Tips

power-pivot-excel-school-introduction-and-benefits-v4

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts