4 Replies Latest reply on Nov 6, 2018 9:43 AM by Russell Gilbert

    Rank Top N and 'All Other' Using Date Filters

    Russell Gilbert

      I am attempting to create a table vendor invoice amounts for a single quarter. I created a set for vendors, so if the rank was > Top N, then the vendor name becomes 'All Other', grouping the invoice amounts together. I am using date filters rather than a parameter (which I can do) so that the filters will be updated automatically with new dates coming in future updates of the data. What's happening is that I lose a vendor or 2 when the Top N is reduced, and I can't figure out why.

      Here's the Top 12 list:

      And here's the same list with Top N = 5; notice that I lost Vendor F:

      My workbook is attached, v2018.1.

       

      thanks,

       

      Russ