Ranking with Dimension

[GraceGao]

Hi Experts,

i have data set material, sales amount and would like to get ranking for some specific material.

Please help. 

Thanks in advance

[agni_gold]

=Aggr( num(rank(sum(sales amount),4)) , material)

This will give you the rank of each material based on Sales amount in Descending order.