Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Creating Many PivotTables From One.mp4

K2 Enterprises
5.09K subscribers
681 views 14 years ago
Suppose you have created an Excel PivotTable that summarizes sales data by quarter, by product line, and by item. Further, suppose that you have added a Report Filter to the PivotTable that allows you to filter by Region. Now, in anticipation of a staff meeting with all of the Regional managers, you would like to create a separate PivotTable for each Region so you will not find yourself constantly changing the Report Filter. Is there an easy way to quickly create many PivotTables from one? Of course -- it goes by the funny name of Show Report Filter Pages. ...more
...more
Creating Many PivotTables From One.mp4
3Likes
681Views
2011Mar 22
Suppose you have created an Excel PivotTable that summarizes sales data by quarter, by product line, and by item. Further, suppose that you have added a Report Filter to the PivotTable that allows you to filter by Region. Now, in anticipation of a staff meeting with all of the Regional managers, you would like to create a separate PivotTable for each Region so you will not find yourself constantly changing the Report Filter. Is there an easy way to quickly create many PivotTables from one? Of course -- it goes by the funny name of Show Report Filter Pages.

Follow along using the transcript.

K2 Enterprises

5.09K subscribers