2 Replies Latest reply on Jul 7, 2016 12:41 PM by Charles Given

    How to populate the column value that corresponds to a max value in another column?

    Charles Given

      In full disclosure, I'm a total newb to Tableau... Now on to my question...

       

      I'm creating a crosstab from a data set with multiple line items per "Order"... each line item has a unique "Invoice Date", "Invoice Amount", and "Order Notes".  I'm looking to aggregate the line items to get one row per "Order"... displaying the most recent "Invoice Date", and the associated "Order Notes".

       

      I've nailed down the latest "Invoice Date" by simply setting the measure to Max, but this does not work as nicely for the (text) "Order Notes".  How to get one aggregated row per "Order" that displays the "Order Notes" associated with the latest "Invoice Date"?

       

      So I'm essentially trying to turn this...

      Into this...

      I am hoping this is an easy one to explain, but will mock up a sample workbook if that is easier... Thanks!