Pivot Table Options

Copper Contributor

How can I get on my pivot table the Option:

Show report pivot tables

1 Reply


To access the "Show Report Filter Pages" option in a PivotTable, follow these steps:

  1. Select any cell within your PivotTable.
  2. Go to the "PivotTable Analyze" or "Analyze" tab in the Excel ribbon. This tab appears when you have a cell within a PivotTable selected.
  3. In the "Actions" group, you should see an option named "Options." Click on it. This will open a dropdown menu.
  4. In the dropdown menu, you will find the "Show Report Filter Pages" option. Click on it.

This option allows you to create separate worksheets for each item in your Report Filter, which can be useful for analyzing data individually. Each worksheet will contain a separate PivotTable filtered for the corresponding item in the Report Filter.

Keep in mind that the availability of this option might vary depending on the version of Excel you are using and the layout of your PivotTable. If you don't see this option in your version of Excel, you may need to explore alternative methods for achieving similar results. The text and steps were edited with the help of AI.


My answers are voluntary and without guarantee!


Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.