Error with show data - pivot tables

Occasional Visitor

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?

0 Replies