Global filter being overwritten by drill-down
Hello,
I am having a bit of an unfortunate interaction in one of my dashboards, where our customers are in a hierarchy with Country, Chain, Customer. People can filter on a global criterion using this hierarchy, and when they only use the global criteria all the measures are correct.
The problem arises when a person drill-down on a country in one of the cross-tables in the dashboard while also using the global criteria. In this case the drill-down will overwrite the remaining cross-tables in the analysis and show totals for the whole country selected ignoring the customer limitation set in the global criterion.
I have had success with splitting up the global hierarchy (where they use the global criteria to choose chain and customer and the table to choose country) however I would like to hear if it is possible to keep it to one hierarchy and force cross-tables to adhere to what was selected even if you then drill-down on a country.
Thank you in advance
/Bo


Comments
2 comments