Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with top 10 stores by sales and I want to assign ranks 1-10 based on their sales in a straight table.
Can this be done? If so, how?
Thank you,
Amit
Try to use a chart object-> Straight table and add in expression.
=aggr(rank(sum({<District=>}Sales)),Sales)
May be this!!
if(aggr(rank(sum(sales)>10,sum(sales))))
--Surendra
Try:
= Aggr(Rank(Sum(Sales)) <=10, YourDimField)