Show PivotTable Report Filter on Different Sheets

0 Flares 0 Flares ×

The report filter is fantastic for analysing Excel PivotTable data. It allows you to filter the PivotTable using any field from your data source.

An awesome feature called Show Report Filter Pages will display each report filter result on a different sheet of your workbook. This works great when there are only a few filter criteria.

This feature always goes down well in training sessions. It allows you to quickly and easily create multiple reports on different sheets of a workbook, based on the criteria you want to use.

Use the Show Report Filter Pages Tool

  1. Set up the PivotTable as you would like it to look. Add the field to the Report Filter field that you want to use.

The image below shows a simple PivotTable with the Country field being used in the Report Filter field.

PivotTable with Country field in Report Filter

  1. Click the list arrow for the Options button on the Options tab of the Ribbon and select Show Report Filter Pages.

Options button under PivotTable Tools

  1. Select the Report Filter you want to create pages for and click Ok.

Select the Report Filter you want to create pages for

  1. Worksheets will be added to the workbook for each option in the Report Filter.

Related Tutorials

Create a dynamic range name in Excel

Grouping PivotTable data

Change the PivotTable formula

Leave a Reply

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