19 Replies Latest reply: Feb 13, 2018 9:41 AM by Denis LOMAKIN RSS

    Rank Function with Multiple dimensions

    Denis LOMAKIN

      Hi All,

      I have Question about rank function.

      I need create pivot table with 4 dimensions: National, Dealer Zone, Dealer District and Dealer. and one measure let say it is sum(sales), (in reality I have much complected measure)

       

      Then I need to rank each Dealer's sale with every dimension.

      For example if Dealer's 1 sales will be rank 50 in National Level; rank 20 in Zone level and rank 5 in District level.

      Something like below.

      Any suggestions?

      Ranking.PNG