3 Replies Latest reply: Apr 13, 2017 10:55 AM by Krutika Tembharey RSS

    Rank on multiple dimension

    Krutika Tembharey

      Hi All,

       

      I have a straight table which ranks Top 10 products based on their sales, for products with equal sales I get same rank. When the ranks are same I want to rank those products based on their market sales.

      I have the below table,

      abdc_rank_demo1.JPG

      For example , Products P1,P2 and P5 have same rank 9, now I want to rank them 7,8 and 9 based on their market volume.

       

      I am using the below expression,

       

      If(Aggr(Num(Rank(Sum (Volume))),Product) = Aggr(Num(Rank(Sum (Volume))),Product),

      Aggr(Num(Rank(Sum (Volume),4,1)),Market,Product),

      Aggr(Num(Rank(Sum (Volume),4,1)),Product))

       

      Which gives me the below result,

      abcd_rank_2.JPG

      As you can see here, I get discontinuous rank.

      Here the expression ranks the products based on their market volume but again starts the ranking from 1.

      I want to keep my interactive sort active so as the user can understand how the sorting is taking place here and need a continuous ranking on the products.

       

      Can someone suggest a solution on how can I achieve this scenario?

       

      Regards,

      Krutika