1 Reply Latest reply on Nov 14, 2016 8:17 AM by Łukasz Majewski

    Filter for Top N Using a Sort Field

    michelle.smith.2

      Hi.  I'm trying to keep the Top X choices based on the last value of a rolling 12 month period.  In the attached workbook in the Trend Graph sheet, I have a sortStateField that computes the last rolling 12 month value for sum of sales by sub-category in descending order.  The graphs show a rolling 12 month trend where each point represents the prior 11 months, inclusive.  My question is how to I filter and only keep the top 5 shown?  Every time I drop in the In top N? filter I have ([Rank] <= [Top X Choice]) my results get messed up.  Is there an equivalent windows rank or something?  thanks.