3 Replies Latest reply on Mar 5, 2013 1:53 AM by Daniel Ong

    Sorting of String behind aggregation

    Nathan Schofield

      Hi All,

       

      I want to aggregate some rows of data to sum measures. I group by a certain field and want to view for another field the MAX string. The problem is Tableau returns the MAX string by alphabetical order (I think), but I want to return the MAX string ordered by another field.

       

      My example data looks like so:

      Name

      Month

      Score

      Team

      Jim

      2012-01

      6

      Red Dragons

      Bob

      2012-01

      10

      Blue Cows

      Sarah

      2012-01

      15

      Orange Suns

      Jane

      2012-01

      11

      Grey Wolves

      Jim

      2012-02

      11

      Red Cars

      Bob

      2012-02

      10

      Blue Cheese

      Sarah

      2012-02

      9

      Orange Oranges

      Jane

      2012-02

      9

      Grey Owls

      Jim

      2012-03

      9

      Red

      Bob

      2012-03

      7

      Blue

      Sarah

      2012-03

      10

      Orange

      Jane

      2012-03

      9

      Grey

       

      In the attached workbook I aggregate all the months together and group by Name. I want to show the latest team name (i.e. from 2012-03), but Tableau shows the MAX by alphabetical order. How can I show the MAX ordered by Month?

       

      Nathan