3 Replies Latest reply: Jan 25, 2013 10:39 AM by Anil Uckunkaya RSS

    How to display name with highest score

      I want to make a table which displays the name with the highest score of each exercise. The data is loaded from an excel spreadsheet like this:

       

       

      exercisenamepoints
      exercise1nameA10
      exercise1nameB23
      exercise1nameC40
      exercise2nameA16
      exercise2nameB12
      exercise2nameC6
      exercise3nameA4
      exercise3nameB8
      exercise3nameC5

       

      This is how I want the result table to look like:

       

      Exercisewinnerpoints
      exercise1nameC40
      exercise2nameA16
      exercise3nameB8

       

       

      I am using exercise as dimention and max(points) for points, but how do i set up the expression for winner?