8 Replies Latest reply: Nov 8, 2017 8:22 AM by Sunny Talwar RSS

    Need Rank on Sum of Ranks

    Dan Coen

      I have 4 columns that I am using to create ranks from other measures:

       

      For the 4 columns I am using the below expression:

       

      Aggr(

      Rank(

      $(variable)

      4,1),

      Rep)

       

      I then add the 4 columns together with the below expression into "Sum of Rank"

       

      Column(6) + Column(7) + Column(8) + Column(9) (stored in variable "Sum_of_Rank")

       

      Then, in the column "Final Rank", I am attempting to rank on the "Sum of Rank" with the below expression.

       

      Aggr(

      Rank(

      $(Sum_of_Rank),

      4,1),

      Rep)

       

      However, this is not working. I believe the problem is traced back to the Columns being added in the measure. Any ideas? Some data below

       

      QTD Power RankingQTD Power Ranking QoQQTD Power Ranking QoQ%QTD PTQ RankingSum of RankFinal Rank
      4441325-
      7662948-
      141616248-
      2313131564-
      2555365-
      13994172-
      5885879-
      628281981-
      2120203495-
      3025251696-
      329293899-