Possible to hide the detail but showing the subtotal in Matrix Table

[roytap]

Hi,

If i have 3 product group with details, but i only want to show 2 of the product group details but the subtotal of all 3 product group, is that possible?? 

There is currently no option to hide/show detail but only available for subtotal and grandtotal in the properties. 

Thanks in advanced for any suggestion.

Best Regards,

Roy

[v-juanli-msft · Accepted solution]

Hi @roytap

Do you put column “Details” in Rows field?

Here is a workaround.

You can create a new column

newColumn = IF([product group]="product groupC",BLANK(),[Details])

Best Regards

Maggie