How to add rank # as column in straight table

[Anonymous]

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

[mrichman]

Try to use a chart object-> Straight table and add in expression.

=aggr(rank(sum({<District=>}Sales)),Sales)

[surendraj]

May be this!!

if(aggr(rank(sum(sales)>10,sum(sales))))

--Surendra

[vishsaggi]

Try:

= Aggr(Rank(Sum(Sales)) <=10, YourDimField)