From aggregated value text sheet we cannot filter the chart. Actions are something similar to filters, if we can click on any object it will take the dimension from source and apply the same dimension as filter in target sheet.
The reversal will be possible, we can simply navigate worksheets using worksheet actions.
Check the attached workbook, I have implemented the same. Let me know anything else you need!
Actions_10.5.twbx 350.7 KB
Hi Akram ,
Thanks for your reply , I am using 10.2 version so I am not able to open your file .
Requirement is to drill down means chart should show filtered number . I know reversal is possible .
I do not have requirement to simply navigate using action .
I have tableau 10.5 version, unfortunately I couldn't downgrade the workbook to 10.2. That option is available from 2018 versions only.
From your response I can sense that you are expecting a qlikview kind of filtering in tableau.
But there is a limitation in tableau that we can't filter from an aggregated number without a dimension.
Alternates are use the same calculated measure in sheet one, Add that to filter-> choose Add to context -> Then right click choose apply all using this datasource.
Another method we can try is use Tooltip filtering in tableau.10.3 Features | Tableau Software