I was recently asked to separate my years out rather than have them stacked. Once I did that my Top N and Bottom N filters stopped working properly. I want to see my Top N and Bottom N for each year but it seems to prioritize the highest year and not show the top and bottom N for each year see below. I would like to be able to compare each years top revenue and bottom revenue but for some reason its only showing top and bottom for 2022 not all 3 at once.
I took screen shots of top 1 and bottom 1 selected and how it shows 4 data points and then when I move it to top 2 and bottom 2 (should show 4 bars on each year) that doesn't work properly either. when I focus on 1 year at a time it works right but not when all 3 are selected. You can see I have DMA (market) and year as a context filter which helps get this to work with 1 year selected or stacked bars. I also attached my top N and Bottom N sets how I made them.
Is there a calculation I can write to make sure this works properly?
Thanks everyone!
Hello, I just updated the attachments.
As you can see the set filter is acting wonky or at least its not acting how I want it. I would like to see all three years top and bottom revenue. when I have one year selected it works correctly as shown. However, as soon as I add a second year into the mix something breaks.
