cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
webportal Member
Member

Matrix - How to remove the grand total and keep subtotals?

Hello,

 

Is there a way to keep the subtotals and remove the grand total in a matrix?


For example, in the following matrix, it doesn't make sense to add values for multiple years of sales (thus, also to keep a grand total row), but it is necessary to add values for different months in the same year:

 

Capturar.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Matrix - How to remove the grand total and keep subtotals?

@webportal,

 

Download the latest version and refer to picture below.

Capture.PNG

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Highlighted
Community Support Team
Community Support Team

Re: Matrix - How to remove the grand total and keep subtotals?

@webportal,

 

In the Format section of the Visualizations pane, expand the Subtotals card, turn the Row subtotals slider to On and then Per row level slider.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
webportal Member
Member

Re: Matrix - How to remove the grand total and keep subtotals?

@v-chuncz-msft thanks, but it's not working..

 

Capturar.JPG

 

I can either remove ALL subtotals or enable them ALL, but can't find out how to remove the grand total only.

Community Support Team
Community Support Team

Re: Matrix - How to remove the grand total and keep subtotals?

@webportal,

 

Download the latest version and refer to picture below.

Capture.PNG

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
webportal Member
Member

Re: Matrix - How to remove the grand total and keep subtotals?

@v-chuncz-msft ah, the latest version...

Thank you Microsoft :-)