Not if it is applicable in your scenario but I think you should evaluate the capabilities of "Scaffolfding".
Scaffolding is explained here Vizible Difference: Data Scaffolding in Tableau
Hope it helps.
You are a total star! Thank you so much… that’s done it. I’ll mark as answered when I’m next on the internet. So easy when you know the answer!