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: