I’m looking to use Top N to have a dynamic bar chart that shows the Top 10 locations at my business and then lumps all others into an “Others” bucket. I walked through some of the other Top N solutions but I don’t think they quite applied. I need to still show Location Name for the Top 10 locations, but then have an 11th bar that shows “Others”. All the solutions I’ve seen seem to point to another table that might hold the category rankings but that won’t work for me as I need to actually show the location name along with that extra “Others” row.
The other twist I have is that they want to show 1 measure in the bar chart but have the Top 10 be based on another measure. So the end result would show a bar chart with 11 bars…Top 10 locations based on a Case Count Measure, but the measure actually shown in the bar chart is a different one, in this case a % Rate achieved.
I’m not sure if this is quite possible or not. Appreciate any help!