how to display subtotal of one column but not the grand total

[AishwaryaS]

Dear All,

I have 10 columns in a maxtrix, out of which I want the subtotals of all 10 columns but the grand total of only 9 columns.

So basically I want the subtotal but not the grand total of only one column. Remaining 9 columns must have both subtotal and grand total.

Please let me know if its possible.

Regards,

Aiishwarya S

[v-tangjie-msft]

Hi @AishwaryaS ,

As far as I know, you can choose the option to turn off total rows/columns by selecting the fields that need to cancel the total row/column in subtotal according to your own needs:

You can follow the options in this screenshot to do an internal test according to your needs.

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[AishwaryaS]

Hi,

I tried the above method but it doesn't seem to work. 

Its turning off my entire grand total row. Is there any other work around to disable grand total for only one column ?

Regards,

Aishwarya S

[v-tangjie-msft · Accepted solution]

Hi @AishwaryaS ,

In the matrix visualization format -> Feild formatting -> select the feild you want to hide the total and change the color of the font as same as background. Make sure to toggle ON the "Apply to total" in same Feild formatting section. The text/value will get blend into the background, thus hiding it from user.

You can refer to the following posts that may be helpful to you:

Solved: Disable total of text column in Grand Total. - Microsoft Power BI Community

Solved: How to suppress row totals in matrix report - Microsoft Power BI Community

Solved: remove total of one column - Microsoft Power BI Community

Hide Total For Selected Column In Power BI Table - % (foresightbi.com.ng)

Matrix Visual In Power BI: Controling Totals & Subtotals - Enterprise DNA

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.