2 Replies Latest reply on Jul 23, 2012 3:54 PM by Daniel Carr

    How to display MAX result AND other fields associated with MAX record

    Daniel Carr

      Hello,

       

      We have the following data:

       

      NameValueDate
      John221/1/2011
      John335/1/2012
      Sam443/1/2011
      Sam557/1/2012

       

      We can easily get the MAX Value per Name by adding field 'Name' to Rows and aggregatng MAX(Value) for the measure.

      i.e. We get John - 33 and Sam -55.  But we'd also like to get the date associated with that MAX value.  i.e. John - 33 - 5/1/2012 and Sam 55-7/1/12.

      How can this be done in Tableau?

       

      Thanks,

      Dan