Excel - PivotTable: Show Report Filter Pages - create many PivotTables at one time by Chris Menard

Excel – PivotTable: Present Report Filter Pages – create many PivotTables at one time by Chris Menard



Excel has a fantastic function that permits you to create a number of PivotTables from one PivotTable. It’s referred to as “Present Report Filter Pages.”
To make use of this function, it’s a must to use the Filter space in a PivotTable. The sector you need to drag to the Filter space of the PivotTable is the sector you want to create many PivotTables.

For example, in order for you every Gross sales Rep to have their very own PivotTable report, and you’ve got a area referred to as Gross sales Rep, you’d drag Gross sales Rep to the filter space. You want two different fields. Most probably, one is within the row space, and the opposite area, normally numeric, is within the values areas. Here’s a screenshot of how it could look.

Chris Menard’s Web site:

3 thoughts on “Excel – PivotTable: Present Report Filter Pages – create many PivotTables at one time by Chris Menard

  1. Thank you. how we can generate sheets only related to 2 or 3 Filters criteria? i have 3 Levels Filters, but still generating all sheets, which i do not need all sheets.

  2. Thanks for this video. But when selecting "Show Report Filter Pages…:", the worksheets are created correctly for each person but the formatting of the initial Pivot Table is not totally preserved. Can you help me please. Merci

Leave a Reply

Your email address will not be published. Required fields are marked *