I have many pivot tables in one sheet.
Lets say the total number of rows are 100.
On one pivot table, I have filters and measures from the data set and my total is 50.
I want to see just these 50 records.
When I double click on the total 50 cell in the pivot table, it opens a new sheet with the complete data set of 100 records and not my filtered 50 records.
Why is this?