This looks great and you have a lot here so I'm not certain if this is the right solution without taking more time to get familiar with your workbook but it seems you can solve this by adding Product Category (New) to your Selct for SKU dtail Action. Then add Product Category (New) to Detail on the Range Drill 2 worksheet.
One note, this activates the SKU drilldown but it altered your Bubble view on Range Drill 2 so I'm not sure it that is correct. If this is not correct, hopefully it helps.
Thanks and best,
Thanks for coming back to me so quickly. I had tried that but it doesn't work as Product Category(New) is not on the Range Drill 2 sheet (which is the Range Detail Dash).
I thought that as I applied the action filter that is applied to Range Detail (generated by the action from the Category Dash) also to the SKU detail sheet it would all work.
No problem Ed. To get the action to work, I believe you will need to add Product Category(New) to Detail on your Range Drill 2 Sheet. I was able to get this to work but adding Product Category(New) to Detail did change the Bubble Chart to the Product Category(New) level of detail and splits into more bubbles for Customer and Category. I'm not sure if this is correct or not but I think it's necessary for your Action to work as intended unless I've misunderstood.
Is this what you intend the Action to do?