I am creating a dashboard which the user has the option to expand from Category to Subcategory to Brand and so forth on a data table. In the same dashboard I have a couple charts (sheet 2 and 3) which I want to provide the same level of information that sheet 1. I tried using the action filters but it only works if you are actually filtering (duh!) not expanding/collapsing a hierarchy.
Please help! Thanks!
I don't think it is possible to do what you are describing, i.e. sync hierarchy expand/collapse action across multiple sheets.
There might be some workarounds to achieve the same objective using other functionality instead of hierarchy expand/collapse, but that depends on your exact situation.