Sign up for our Excel webinar, times added weekly: [ Ссылка ]

Learn how to quickly create multiple pivot table reports with the Show Report Filter Pages feature.

Download the file to follow along: [ Ссылка ]

Get the Tab Hound Add-in: [ Ссылка ]

Pivot tables are an amazing tool for quickly summarizing data in Excel. They save us a TON of time with our everyday work. There is one "hidden" feature of pivot tables that can save us even more time.

Sometimes we need to replicate a pivot table for each unique item in a field. This could be a report for:

Each department in organization.
Each salesperson on the sales team.
Each account in the general ledger.
Each customer in the CRM system.
Each stock in the database.
Or, just about any other field (column) in your data set.
We could create one pivot table, filter it for a specific item, then copy the sheet and re-apply a filter for the next item. But this would take a lot of time if we have dozens or hundreds of unique items in the data set.

Fortunately, we don't have to do all this manual work. Pivot tables have a feature called Show Report Filter Pages that automates this entire process.

The Show Report Filter Pages Feature

The Show Report Filter Pages feature:

Creates a copy of an existing pivot table for each unique item in a field.
The new pivot tables are created on individual worksheets.
Each sheet is renamed to match the item name.
A filter is applied to the field in the Filters Area of each pivot table for the item.
All this is done with a click of a button. Your field can have 5 or 500 unique items. Show Report Filter Pages will create a sheet for each item and replicate the pivot table report.

свернуть