1 Reply Latest reply: Apr 30, 2012 8:41 AM by Martin Grape RSS

    Highest

      Hi,

        • Highest Value

          Hi,

          I have one sulution that is working, don't think it is the best one though:

           

          Dimension 1 --> Team

          Dimension 2 --> =SUBFIELD(AGGR(MINSTRING(1/Score & '|' & Name), Team), '|', 2)

          Expression --> MAX(Score)

           

          Don't know what happens if several persons in same team have same score.

           

          Cheers