Forum Discussion
Solved
Allselected filtering data hierachy
Hi everybody, When trying to delete hierarchy date filtering with ALLSELECTED in a matrix with date(rows) and Countries(columns), first hierarchy level (year) works well but the other (quarter, ...
Syndicate_Admin
You need to also add the columns [MonthNo] and [QuarterNo]
(Alltough you don't see them in the visual they are used in the query that creates it in order for the months and quarters to be sorted correctly)
Syndicate_Admin
You need to also add the columns [MonthNo] and [QuarterNo]
(Alltough you don't see them in the visual they are used in the query that creates it in order for the months and quarters to be sorted correctly)
Thanks a lot, I was convinced it should be easy but don't found it. You helped me.
You are welcome. My pleasure.
Could you please mark this as a solution 🙂
Thank you