I would like to show Top 5 accounts based on Sales $ Growth. Attached are the fields I am using in my table. Sales $ Growth is a variable. The variable name is vNetSalesYTDGrowth$. What formula would I use?
Go to Solution.
Thank you so much. The formulas work as intended. Appreciate the quick response.
You could use a calculated dimension like so:
Aggr(if(rank($(vNetSalesYTDGrowth$), 4,1) < 6, Account), Account)
Thank you for your response. What about the Bottom 5?
Add a minus operator to the value you are ranking.
Aggr(if(rank(-$(vNetSalesYTDGrowth$), 4,1) < 6, Account), Account)