Forum Discussion

PLKRLAS1's avatar
PLKRLAS1
Frequent Visitor
3 years ago
Solved

undefined

Dear Community,   I have a problem with matrix table. I want to see only grand total for the whole table without row-subtotals. However when I am switching-off row-subtotals, I am not able to see ...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi PLKRLAS1 ,

    You can set it like this:

    1. Turn on the "Row subtotal" option.

    2. Turn on the option "Apply settings to Per row level", and select sub_category in the drop down option.

    3. Turn off the "Show subtotal" option.

    Get the correct result:

    Best regards,

    Community Support Team_yanjiang

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi PLKRLAS1 ,

You can set it like this:

1. Turn on the "Row subtotal" option.

2. Turn on the option "Apply settings to Per row level", and select sub_category in the drop down option.

3. Turn off the "Show subtotal" option.

Get the correct result:

Best regards,

Community Support Team_yanjiang

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