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?

      Hi

       

      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.

       

      Cheers

       

      James