G GN0001 Member May 1, 2011 #1 I have a pivot table that has a filter. Two fields of pivot table are sitting in Row and column, and both have filter. When I filter the column, I need to filter the row but I need row shows the first top 10 Value? How? Thank you for the help. Guity
I have a pivot table that has a filter. Two fields of pivot table are sitting in Row and column, and both have filter. When I filter the column, I need to filter the row but I need row shows the first top 10 Value? How? Thank you for the help. Guity
srinidhi Active Member May 10, 2011 #2 What do u mean by first top 10 Value, is it same as top 10 Value or not. To get top 10 Value, you can try the below mentioned method. Click on the filter & Value Filters & select TOP 10, you will be able to see the 10 values available in that pivot table
What do u mean by first top 10 Value, is it same as top 10 Value or not. To get top 10 Value, you can try the below mentioned method. Click on the filter & Value Filters & select TOP 10, you will be able to see the 10 values available in that pivot table
J jhargram New Member May 10, 2011 #3 You just click that filter in Pivot Table, you can get one option top 10.
