3 Replies Latest reply on Nov 15, 2016 7:45 AM by michelle.smith.2

    Struggling with filtering for top 5

    michelle.smith.2

      I'm trying to get Tableau to only show the top 5 based on the amount in the last 12 month period.  In the example in the Trend Graph sheet, the graph shows a trend of the 12 month look back period during 2013 (so Jan 2013 really represents the sum of sales from 2/1/12 - 1/31/13).  I have the data sorted correctly using the SortStateField calculation, but I can't figure out how to get Tableau to only show the first five.  the SortStateField is using a Window_Sum calculation, and I cna't seem to filter on that.  Any help would be greatly appreciated!!