I have two worksheets on a dashboard. Both worksheets come from the same data source and use the Superstore Product hierarchy.
The requirement is that the drill downs stay in sync across the two workbooks.
If the user drills down on Category in the Profit worksheet, the same should happen in the Order Date worksheet.
Anyone know how to link these?
Is there a way to know the hierarchy level selected?
Is there a way to force a hierarchy level from a calculation or parameter?
Is there an action that recognizes the hierarchy?
I've included a Hierarchy.twbx.
Retrieving data ...