SOLVED

Different Pages in Pivot Table

Copper Contributor
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.
4 Replies

@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/

best response confirmed by Rilwan (Copper Contributor)
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
Very easy steps to understand.

Thanks
You're welcome
1 best response

Accepted Solutions
best response confirmed by Rilwan (Copper Contributor)
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

View solution in original post