6 Replies Latest reply: Apr 18, 2017 2:16 PM by Lucas Westmaas RSS

    Rank within group

    Lucas Westmaas

      Hi,

       

      I'm trying to produce a table that shows ranks within group. Take the data below:

       

      OfficeGroupScore
      1A5
      2A9
      3A1
      4B10
      5B19
      6B5
      7B3
      8B4

       

      I haven't been able to produce rank within group. For example, the rank for Office 2 should be 1 because they are the top office in Group A even though there are two offices in Group B with a better score.

       

      I need to be able to do this even if Group is not part of the visualization, if that makes a difference.

       

      I'm guessing the solution requires AGGR but I haven't been able to get it to work.

       

      Can anyone help? Thanks in advance!

       

      Lucas