Forum Discussion
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, month, day) don't delete their filter although using multiple columns in ALLSELECTED. How could I solve it? Thanks a lot for your help !!!.
(Figures not in bold should match the total column ones)
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)
3 Replies
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
