Sorry I dont have a option to look into your workbook in my machine,Here are my suggestions.
In your first dashboard select the first report and right click on it ->select use as filter option or select dashboard->actions -> add actions -> select the first dashboard name-> check the first report name-> on right side you can see Run action on option there 'select' option and below can select the second report in same first dashboard . Below in Target fileds mention the column where you can apply the filter.
Then for navigation to another dashboard, Select the first dashboard name in source sheets and second dashboard name in Target sheets box. Then on right side you can see Run action on option there click 'select' option
In Target Filters ->select ->selected fields radio button and click ok.
You should be able to do it..Pls let me know if you have any questions
1 of 1 people found this helpful
I have modified your workbook. now it filters correct.
I think it stuck before. when we drill one category it will show all previously.
now it wor
Thank you - but I notice that the filter still down not work correctly. It appears to filter based on the umbrella chart and not the Cancellation Rate Chart? So selectinv the top left chart affects all other charts on that dashbaord, as well as dashboard 2. But clicking on the lower chart takes you to Dashboard 2, but not filters it?
When we filter data from umbrella chart then it will filter data in other charts.
when we select GYNAECOLOGY in cancellation rate chart then it will filter data and show dashboard 2 with only GYNAECOLOGY data.
i checked it works.
You are correct, but that was not what I wanted it to do - I wanted it to do a two stage filter. The first to affect the charts on the first dashboard, then second to show a further subset of the filter that you helped with. I think it is this two stage filter which is causing the problem - maybe Tableau cannot cope with this?!?