Error with show data - pivot tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2263532%22%20slang%3D%22en-US%22%3EError%20with%20show%20data%20-%20pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2263532%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20many%20pivot%20tables%20in%20one%20sheet.%3C%2FP%3E%3CP%3ELets%20say%20the%20total%20number%20of%20rows%20are%20100.%3C%2FP%3E%3CP%3EOn%20one%20pivot%20table%2C%20I%20have%20filters%20and%20measures%20from%20the%20data%20set%20and%20my%20total%20is%2050.%3C%2FP%3E%3CP%3EI%20want%20to%20see%20just%20these%2050%20records.%3C%2FP%3E%3CP%3EWhen%20I%20double%20click%20on%20the%20total%2050%20cell%20in%20the%20pivot%20table%2C%20it%20opens%20a%20new%20sheet%20with%20the%20complete%20data%20set%20of%20100%20records%20and%20not%20my%20filtered%2050%20records.%3C%2FP%3E%3CP%3EWhy%20is%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2263532%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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