The attached workbook uses the instructions in Creating a Stacked Bar Chart Using Multiple Measures | Tableau Software to create one stacked bar chart.
You may also consider pivoting your data, so that you can use the instructions in Percent of Total Adds Up to More Than 100% | Tableau Software
Hope this answers your question!
SS sample dataset-modified.twbx 19.9 KB
that has definitely helped, particularly the how to create a stacked bar chart using multiple measures, I am pretty sure I used it in the past, but I must have absolutely forgotten it!