Top 10 filter doesn't take each year into account separately.
I have data setup in pie graphs showing products ordered in each year. When I trellis them so that multiple years are shown, and then add a TOP10- filter it doesn't show me the TOP10 products ordered for each year, it shows me the TOP10 out of all the years shown.
When I show 2022-2025 the legend should show me 19 products, because in some years the TOP10 are different from other years. What I want is to see the TOP10 from 2020, TOP10 from 2021, TOP10 from 2022 etc. Not the TOP10 for all the years together.
Currently when I use a multiselect it shows me the TOP10 per year only if I select only 1 year at a time.
I spent all day trying to get this to work and cannot figure it out. Is there a way?
5 replies
-
Hi
This can be done using N of N - just select a large number of the first N and 10 for the second one.
Here is where you start - all products, all years:
Then in the query menu check N of N:
and select to 50 years:
and top 10 products:
and here you go:
-
Thank you !!! This is exactly what I was looking for.
-
Spoke too soon. For some reason, the year order changes. Even in your example it changes from 2008, 2009, 2010 to 2010, 2009, 2008.
In mine it changes from 2020,2021,2022,2023,2024,2025 to 2021,2023,2022,2024,2020,2025. I have tried to do a custom re-order of the dates, which still doesn't work. Any idea how to fix that?
-
just add a sort to the years and sort by label.
-
Thanks. That works.
-