2 Replies Latest reply on Feb 6, 2019 1:13 PM by Michael Markman

    Grouping lower ranked items into "Other" and then Collapse when using a filter

    Michael Markman

      Hi All - I've attached a subset of the superstore and done some work to use a parameter and sets to be able to collapse the Top N invoices by sales amount. The next step I want to take is be able to  filter on City and still have it give me the top N for that city and lump everything else into "Others" so I can collapse it. So in the example attached, if you filter on "Decatur" I want it to show the top 15 and put the 16th invoice into "Other" but they are all on "Other" now because it is looking at the full population of invoices even though I'm filtered.

       

      I put a rank formula in as well thinking that might be useful somehow, but can't figure it out.

       

      Is that possible?

       

      thanks,
      Mike