Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning guys,
I am trying to get a report for Top 100 shoppers and i used Dimension Limits but its not showing the accurate result.
Is there a formula i can use for top shopper apart from Dimension limits
Await Ideas Please
You can try to achieve it by using rank() function in calculated dimension
=Aggr(
If(Rank(
Aggr(
<yor expression here>
, [Your Field])
, 1, 0) <= 100,
[Your Field] )
, [Your Field] )
Try like this:
=if(aggr(Rank(Sum(Sales)),Product) <=100, Product,Null())
or
=aggr(if(rank((sales))<=100,Product,'Others'),name)
or
=Sum({<Customer = {'=Rank(Sum(Sales))<=100'}>} Sales)