top 3 in pivot table

[Anonymous]

Hi ,

How to get the top 3 sum(Sales) in pivot table as we don't have dimension limits in pivot table

Thanks

[krishna20]

Hi,

Please edit this expression as your accordance and place it in the Calculated Dimension.

if(rank(Sum(Sales)) < = 3, Sum(Sales))

or

=AGGR(If(Rank(sum(Sales))<=3,Brand),Brand)

Regards

Krishna