8 Replies Latest reply on Feb 21, 2020 8:06 PM by Bryce Larsen

    "Top X" filter for each Month, (Not all Months)

    Jeremy Johnson

      Hello everybody, I'm having a rare setback figuring out how to implement a filter.

       

      Basically, I have a values per month for different people. Those values are split across two different categories.

      I'd like to find a way to create a "Top X" filter,  using either Index or Sets to allow me to select "top 3" or "top 4" etc,  and have each top value / person appear in each month.

       

      Some people have higher totals in some months and lower totals in some months, so i need this to truly reflect the top value for each month.  When I try it, I can only get people to show up in each month, based off their grand totals for all months.