Grandtotals

HI mmills2018 

You can try creating a Dummy column (Total = "Total" ). This will act as a parent level hierarchy for any categorical column present in same table.

Now, create a matrix with this dummy column and your actual categorical column in "Rows" and measue in "values"

Set the metric to lowest level of data by clicking icon as show below:-

Go to "Format" for Matrix visual -> Go to "Subtotals" section

Set

Row Subtotals = On

Row Subtotal Position = Top

Per Row Level = On

More options would appear

Set Total = Offand rest all = On

Got to  "Format" for Matrix visual -> Go to "Row Headers" section

Set 

Stepped Layout indentaion = 0 

and you table should look like below:-

Amazing! worked perfectly, thank you!!!