Filter on a Pivot Table to get the First 10 Value

[GN0001]

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]

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

 

[jhargram]

You just click that filter in Pivot Table, you can get one option top 10.