Using Total column in a group by for a Table

[Anonymous]

Hi ,

I have matrix visualization, 

Column1  Column2  Column3

A                  10          abc

A                  20          pqr

Total            30          abc

B                  30          xyz

B                  20          xyz

Total            50          xyz

Total             80         abc

I wanted to show Total 30 for Column 2 but not for Column3. Is there any option to hide it. I have disabled Apply to subtotal option for Column 3 in Field Formatting Properties but still it is showing me. 

Thanks,

Shubham

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may refer to below picture.

Regards,

Cherie