One solution could be:
1.- Remove Category from Rows shelf. You don't need to add Category to the table as it is color coded
2.- In Marks, select Automatic
As a result you will have the values colored according to Category. Yes, I know, the whole row is not colored, just the values.
It seems that your want to have a table, but I think it is better to create a bar chart to communicate better your results.
If you decide to follow my recommendation, do the steps:
1.- Remove Category from Rows shelf
2.- Drag the measure Total to Columns
You will have a bar chart with labels (values of SUM(Total), color coded by Category.
I hope this help,
Ramon, great suggestion. I was blinded by trying to replicate something I had made in Excel. It turns out that a bar chart actually works better!
Thanks for your insight
I'm glad my proposal fits your requirements.
Lesson learned: Never think the same way you use Excel when using Tableau.