Pivot table - Top 20

[#1]

I want to show top 20 in a pivot table. So within the other dimensions.
e.g.: per salesperson -> per articlegroup -> Top 20 articles

[renjithpl]

hope sorting will do,

try sort -> numeric value - descending

thanks

[#3]

Hi,

You can use the rank function in calculated dimension to show top 20 Salesperson. Below is the sample:

IF(AGGR(RANK(SUM(Sales)), Salesperson) <= 20, Salesperson)

Please check the checkbox " Suppress When Values is Null" for this calcualted dimension under Setting for Selected Dimension in Dimensions tab.

Please let me knw if you have any more query in this regard.

[#4]

Hi,

Further to more specific to your requirement you can use the below one which will show "per salesperson -> per articlegroup -> Top 20 articles" using the rank function in calculated dimension for article:

IF(AGGR(RANK(SUM(Sales)), salesperson, articlegroup, article) <= 20, article)

Please check the checkbox "Suppress When Values is Null" for this calculated dimension under Setting for Selected Dimension in Dimensions tab.

Please let me know if you have any more query in this regard.

Dhananjay (DJ)

[swarup_malli]

Dhananjay Mishra,

Thank you , it worked for me.