Excel Tip: Multiple Pivots with Report Filter Pages

If you’ve read my blog, you’ll know that I love PivotTables.

Subscribe for more Excel tips and get your free ebook on getting “Hired with Excel.” 

One nuisance with PivotTable is report maintenance. If this is an ongoing report and you want to see data arranged a certain way each time, it can be annoying to re-build your PivotTable each time.

If you have your data filtered by one attribute (say, Quarter) and wish to create a PivotTable filtered by the other values in that field (example, Quarters 2-4), use this trick to have Excel build those PivotTables for you.

Slick. 

 

Multiple pivots (1)

 

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: