This content has been marked as final. Show 2 replies
1 of 1 people found this helpful
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?