1 Reply Latest reply on Apr 11, 2012 10:48 AM by Tracy Rodgers

    How can I return the highest value from 3 columns of data?



      I've been using Tableau for some fairly straight forward interogation of our point of sale system & I'm now starting to look into some calculated fields etc & I'd really appreciate some help with this.


      I'm looking at monthly usage data for our members which at the moment looks a little like this


                          Gym      Swim     Classes         TOTAL

      Member 1        3               5          8               16

      Member 2        0               0          2               2


      How can I add a calcualtion that will return the column name with the highest usage for each member. For example Member 1 would return "classes"


      Any suggestions would be greatly appriciated.