I've attached a workbook with two dashboard actions. I hope this is what you had in mind.
The first action applies to your X output sheets and the second to your Z outputs. You needed a separate action for each set of sheets because otherwise when you excluded values it would clear any data from those sheets.
Please let me know if you have any questions or if I've misunderstood your question.
Testfilev2.twbx 31.9 KB
Hi Lester and Steve,
thank you very much for the quick response :-)
Lester: I like the idea of setting up the filter. But if I change to a different category using the Sheet Selector, it doesn't work further....
Steve: Thank you very much for this approach. I got mine to work with it.
Again, thank you both and I wish you a nice das;