Hi, I think I am doing something basically wrong and it isn't being obvious. I have a pivot table and I want to use the "Show Report Filter Pages" option. In this case the filter is on the last name. I have over two hundred names. I filtered it down to the six names I needed to see and went to PivotTable Analyze > Options > "Show Report Filter Pages" and selected the Name as the filter. It worked, it made over two hundred little bitty PT's even though I checked the main table and it was filtered to six names. So I made slicers that allowed me to filter it by location and name. Same six names and ... it still made over two hundred little bitty PT's. I am sort of at a loss. I can't think of what I did wrong. Thank you for reading.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot Table - "Show report filter pages" shows all.
- Thread starter Mr_Phil
- Start date
