5 Replies Latest reply on Aug 24, 2013 12:11 AM by ashley cherian

    The Rank function goes awry when i move it from the Rows section to the filter.

    ashley cherian

      my data contains details of a list of ratios for each customer, year wise. I am trying to use Tableau to find out the latest available year of data for each customer and then colorcode the Ratio ( High, medium and low)  for the identified latest year. I have a calculated field 'Category' to classify this.

       

      I am using the LAST function and it filters out the latest year just fine. But the moment i move the categories filed to the color shelf, the rankings go all awry (multiple years are shown as latest)  Please see attached screenshots and the file

       

      My first post here, Any help would be much appreciated.

       

      Ashley