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
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 Analyze - Options**
**Show all report filter pages of:**
YouTube video
Excel Report Filters: Tips of creating multiple reports from one PivotTable - YouTube
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
