So with a bit of formatting we can just about do this. Tableau is very different from Excel, which employs a Cell-based system (meaning you can individually edit each cell), whereas Tableau operates like a database.
So first we can remove the Total label here
Then we can set the Parent Column to Blue here
And finally we can get the Total row banding here
Sol we end up with our Table...Excelled!!
Hope that helps
Specific Formatting.twbx 997.0 KB
Thanks for your help. May I know one more thing? in your example, Is it possible to set "Office Supplies" to across Category column (merge cell)? Because some of my data are very large (near to 100 characters). It is better if it can show across category column.
No that I know of, we don't have the option to merge cells. To allow this Tableau would have to let the Category Column contain text from the Department Column. In Excel we can do this, as everything is worked up Cell by Cell (so it doesn't care what you put in each cell)