4 Replies Latest reply on Mar 5, 2012 12:18 PM by Alan Kwan

    Ranking with 2 dimensions

    Alan Kwan

      So I have two dimensions and one measure,

      Dimensions: State, Agent Name

      Measure: Duration

       

      State     Agent               Duration

      a               1                         1

                       2                         4

      b               2                         2

                       3                         6    

      c               3                         3

                       5                         1

          

      I don't know how to create a ranking that ranks the agent within the state.

       

      So with the example on the top, the result should be:

       

      State   Rank  Agent               Duration

      a           2         1                         1

                   1         2                         4

      b           2         2                         2

                   1        3                         6    

      c           1         3                         3

                   2        5                         1

       

      I understand using the index() formula will give me the numbers, but it won't sort according to their sum of durations..please help

       

      Thanks,

      Alan