Grand Total Row on Matrix Tables

[Anonymous]

Is it possible to get a grand totals row appear at the bottom of a matrix table (with no other totals being displayed)?

[SivaMani · Accepted solution]

@Anonymous

Yes.

• Go to Fomat pane -> Row Subtotals
• Change Row subtotal Position to Bottom
• Enable Per row level. You can see the subtotal fields with On by default
• Disable the subtotals for the fields which don't require subtotal

Appreciate your kudos!

Please consider Accept it as the solution to help the other members find it.

Regards,

Siva Mani

[skcary2]

The solution I have found is to ensure that "+/-" icons are turned OFF and that Stepped Layout is turned ON. This should move the totals to the bottom.

[Anonymous]

Thx for getting back to me.  My SubTotals does not look like yours.  See below.

[v-jayw-msft]

Hi @Anonymous ,

You need to turn Row subtotals on.

Best Regards,

Jay

Community Support Team _ Jay Wang

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