top 3 in pivot table

Anonymous — Mon, 19 Jan 2015 07:02:52 GMT

Hi ,

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

Thanks

Re: top 3 in pivot table

krishna20 — Mon, 19 Jan 2015 07:08:49 GMT

Hi,

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

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

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

Regards

Krishna