Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try Rank(TOTAL ....)
Aggr(Rank(TOTAL Sum(BACKLOG_QTY)), INVENTORY_ORG_NAME,LOCATION_CODE,CATEGORY_NAME,PROD_HIER_LEVEL1)