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 possi...
- 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
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
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
