Forum Discussion
Solved
Different Pages in Pivot Table
Hello, I have a task to create different pivot table report to be in separate worksheet. For example, let assume we have the following names in a column repeatedly: Rilwan, Smith and John. If is possible to create pivot table so that we will have all the report for let say Rilwan and Smith in separate worksheet?
Will be glad to get for a solution.
Will be glad to get for a solution.
- Hello,
There is need to use Show Report Filter Pages.
To do that:
1. Drag and drop the field name that contains repeated names of Rilwan, Smith and John, into the FILTERS
2. Click on the Filter and select Rilwan and Smith
3. Click OK
4. Click on the little downward triangle right of Options under the PivotTable group of the Analyze tab of the PivotTable Tools
5. Select Show Report Filter Pages
6. Click OK on the next dialogue box
You will see the PivotTable Report for Rilwan and Smith in separate sheet tabs.
Hope this helps
4 Replies
- Hello,
There is need to use Show Report Filter Pages.
To do that:
1. Drag and drop the field name that contains repeated names of Rilwan, Smith and John, into the FILTERS
2. Click on the Filter and select Rilwan and Smith
3. Click OK
4. Click on the little downward triangle right of Options under the PivotTable group of the Analyze tab of the PivotTable Tools
5. Select Show Report Filter Pages
6. Click OK on the next dialogue box
You will see the PivotTable Report for Rilwan and Smith in separate sheet tabs.
Hope this helps Rilwan If you put the name field in the PivotTable Filter field, you can use the Show Report Filter Pages option, which will create a new worksheet for each name in the list.
See: https://www.excelcampus.com/pivot-tables/show-report-filter-pages/
