How to find rank only Considering single measure field in a table

[Dharanidharan_DD]

Hi,

How to create rank field without considering dimensional fields .

Only based on one measure field.

I Have Measure field Sum(NetWt) , and many dimensions with repeated values . I need to rank only based on Sum(NetWt) field .

[Taoufiq_Zarra]

can you share a sample data and the expected output ?

[Dharanidharan_DD]

[Dharanidharan_DD]

I need to get Purchase Rank . Purely Based on Purchase Weight i.e Sum(NetWt).

I used this expression for purchase rank but I cant find rank num 3.

=aggr( nodistinct Rank( aggr(if(sum(NETWT)>0, sum(NETWT)),Quote,Touch),4),NETWT)