Excel Report Filters: Tips of creating multiple reports from one PivotTable

Posted on:  04/12/2021
Excel Report Filters: Tips of creating multiple reports from one PivotTable

PivotTables are great for summarizing and analyzing data. Report Filter Pages is a great way to generate multiple reports. For example, we have a list of 12 Salespeople and their customer and their orders. We can use Report Filter Pages to create 12 additional reports, one for each rep quickly. I'll demonstrate how to use Report Filters and how to sort and format before creating your Report Filters.

Report Filters in Excel

Report Filters in Excel

Steps to use Report Filter Pages

  1. Create a PivotTable in Excel.
  2. Add the field to the areas in the pivottable areas.
  3. Add the field you want to reproduce multiple reports to the Filter Area. In our example the field is Advertising Source.
  4. Click PivotTable Analyze tab.
  5. Click Options.
  6. In the dialog box Show Report Filters Pages...makes sure the correct field is selected.
  7. Click OK.
PivotTable Fields - multiple reports

PivotTable Fields - multiple reports

PivotTable Analyze - Options

PivotTable Analyze - Options

Show all report filter pages of:

Show all report filter pages of:

Other Excel articles

YouTube video

Download the Excel file used in the video

Excel file used 

Other Excel articles

Video Chapters:

  • 0:00 Intro
  • 0:24 Create PivotTable
  • 0:54 Report Filter
  • 1:34 Formatting PivotTable
  • 1:55 Sorting a PivotTable
  • 2:06 Change Style
  • 2:30 Create Report Filter Pages
Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories