Rank of an expression when there are multiple dimensions in a straight table

[Prabhu]

Hi, could not calculate the rank of an expression. It is showing  rank 1 if is use the following expression:

aggr(Rank( Sum(BACKLOG_QTY)), INVENTORY_ORG_NAME,LOCATION_CODE,CATEGORY_NAME,PROD_HIER_LEVEL1)

Please help me to get the correct ranks for each expression value.

Regards,

Prabhakar Vammi

[sunny_talwar]

Try Rank(TOTAL ....)

Aggr(Rank(TOTAL Sum(BACKLOG_QTY)), INVENTORY_ORG_NAME,LOCATION_CODE,CATEGORY_NAME,PROD_HIER_LEVEL1)