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: