Forum Discussion
Syndicate_Admin
Administrator
AdministratorAllselected 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)
SpartaBI
Community Champion
Community ChampionSyndicate_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_AdminThanks a lot, I was convinced it should be easy but don't found it. You helped me.
- SpartaBI
You are welcome. My pleasure.
Could you please mark this as a solution 🙂
Thank you