I'm not sure if this will suit your setup, but maybe this can give ideas.
Simon Runc posted a brilliant method for sheet swapping using action filters:
I've roughly implemented it in the workbook attached in the Forum Thread:
310207drill.twbx 1.9 MB
Tableau is weak from a UI point of view on the ability to chop/drill into the data
I would challenge this statement. Drilling into data is one of Tableau's strengths, IMHO.
I would also look at a TDT Video I did a while back, where I used the technique Swaroop mentioned to do exactly this
This trick is from around 39:40
I've attached an updated example using this trick on your data (you will have to click each drill twice, as I've not implemented the "self de-selecting toggle" from the video, but this would be easy to add).
btw if you upgrade to 2019.2 the new set/parameter actions make this even easier.
Hope that helps and makes sense.
Thanks for this Simon, I will check it out.
We cant upgrade, we just did a few months back to 2018.3 from 10.5
Sent from my iPhone