I want to remove sub totals, but keep grand total on matrix visual

[ukeasyproj]

Wondering if anyone knows how to do this

when I turn off row total, it does not let me turn on grand total

[v-yulgu-msft]

Hi @ukeasyproj,

As you mentioned, the option "Total Row" which we can turn on/off controls all the total row, including subtotal and grand total.

Currently, it is impossible to disable the subtotals separately in Matrix, some ideas about this issue have been submitted in the following links, please vote it up.

Toggles for Sub-Totals and Grand-Totals on Matrixes

Best regards,
Yuliana Gu

[GilbertQ]

Hi @ukeasyproj

I think some of the options might be available in the new Matrix Preview. There are a whole host of new options in terms of having the Subtotals enabled or disabled. As well as there should be an option under General for the Total Row?