I looked thru your workbook, but quite difficult to understand the issue.
Could you illustrate what is wrong for my better understanding?
(Version 9.3 here)
Here's the problem.
Your actions are passing ALL fields. So when you click on 22, there is only one machine on location 22, and you get the right amount in your other charts. But when you click on 26 or 27, two machines occupy that spot, but only one is the current machine. When you pass all fields, you also pass the current machine, and you get the total only for that one machine.
I made a copy of HA Floor (sheet 11) and CoinIn (Sheet 12). I made a new dashboard (Dashboard2) that uses the two sheets.
I have an action that only passes LOCATION to Coin -in. It gets the correct sum now.
You'll need to do that for all your secondary sheets. (And delete all those extraneous filters that past actions have put on your sheets. All those that start with ACTION(). Start fresh.
Tableau_0501 A.twbx 500.7 KB
I would try this out. Thanks for your quick help. Really appreciate it!
This worked perfectly. I applied it on XY unique instead of location for all the unique location values on map.
thanks for your answer and help with creating quick dashboard for resolution.