That is not what i was looking for , i was looking to filter (based on action) .. when someone clicks on any product in "Sheet 1" then "Sheet 2" should get filtered and from there when someone clicks on any segment e.g. Consumer he should be directed to the "Details" which should be filtered based on the product selected in "Sheet 1" and for the segment chosen in "Sheet 2" , Without adding "Product Name" in "Sheet 2".
In your Actions Menu the filter was set to display on Menu, meaning the user would then hover over the Segment and wait for the Tooltip to display the hyperlink to click and then would take them to the filtered Details worksheet. All I did was change that particular action from MENU to SELECT. That should give you the result you desire, which is on SELECT of SEGMENT name automatically takes the user to the Details for that particular Product. Hope that helps! Thx, Don
Not very clean view, but here is one idea.
You still need to put "Product Name" dimension in sheet2, but only in detail.
Then to show label, instead of text label, I used reference line.
Drawback is the tiny vertical line when you hover over without filtering on Sheet1
Action Filter_SM_10.5.twbx 1.2 MB
Fabulous, with your input i got was partly able to achieve what i was looking for, however this solution has 2 limitation,
1. Imagine user has not made any selection in the top treemap to filter the bar chart below he want to directly use the bar chart to go to details.
2. User makes multiple selection more than 1 selection in the top chart.
You understand where i am coming from .