Thanks for responding. By the looks of the snap you have shared, it is exactly what I was looking forward;
Unfortunately I could not do replicate it. Can you do that on the workbook I attached ?
Also what i have given is a sample data.. I have a host of other charts which are dependent on the Manager filter only; Will your solution work for my scenario ?
Please see the attachment.
I'm using v10.4. You might not be able to open it if you use a previous version.
Here is the detailed instruction just in case:
Step 1: Create a Manager Sheet
Step 2: Drag the Sheet on the dashboard
Step 3: Set up two action filters on the Dashboard
One is the Filter Action from 'Manager' worksheet to 'Spend' worksheet:
The other one is the Highlight Action from 'Manager' worksheet to 'Pie chart' worksheet:
Let me know if you have any question.
piechart db.twbx 29.7 KB