Managed to sort this out Ombir, I completely forgot to link the 2 tables using the common field of customer ID so now works as planned.
Finishing this off tonight as this is a piece of work going to our CEO tomorrow.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...