How to show both row and column totals when having more than 2 column fields in a Matrix

[kadingo]

I want to disply both row and column grand totals, but it doesn't seem to be supported yet it looks basic.

If i want to archieve something similar to the below example, only the totals on the right side are dispalyed but not the totals at the bottom.

If i reduce the columns i have added such that i have only Category and Type, i get my totals as expected i.e i get grand totals both at right side and at the bottom for my 3 groups. Does any one now to archieve the below requirement or an article that demostrates how. 

[v-lionel-msft]

Hi @kadingo ,

Has your problem been solved? If yes, please consider accept it as the solution to help other members find it more quickly.

Best regards,
Lionel Chen

[kadingo]

@v-lionel-msft , my problem has still not been solved. 

[VijayP]

By Default when you select Matrix Table you will get both Row and Column Totals.

[kadingo]

@VijayP  If you supply more than 2 columns to the Matrix's Rows well, the totals at the bottom in my screenshot will not be displayed, if you only supply 2 or less columns, it works. 

So it doesn't seem to work if you have more than 2 category columns, do you have a working example?

[VijayP]

It works irrepctive of any number of columns. Please check this

Regards

Vijay Perepa

[kadingo]

I meant your rows well should be the one with more than 2 columns not the columns well, if you add more than 3 fields to your rows well (highlighted below), does it still work? Do both grand totals display?

[VijayP · Accepted solution]

Yes It works , see the Snapshot.