Subtotals of each group

[samflynn]

This is the table visualization I have:

I want it to look like this below. Basically a total of rows for each of ship-to. Is it possible to do that in Power BI? 

[MFelix · Accepted solution]

Hi @samflynn,

You should use the matrix visual that allows you to have subtotals on rows and columns, if you want the table as is you should disable the option Stepped values on the row options.

Regards,

MFelix

[samflynn]

@MFelix Yes thank you that helps, I hadn't noticed the "expand all down to one hierarchy" in the matrix visual.