Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix visual subtotal

Hi everyone,   really basic question but the new functionality of row subtotals after the update drives me nuts. I just want to create grand total of the sales value field and a subtotal for the Te...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi  Anonymous ,

     

    For this you need to have the subtotals turn off for the leader then you get the following result:

     

    This is based on level so since Division is the the first level will be the grand total so need to be turn on, then team becuase you also want to see it and leader turn off.

    If you don't want total values then you need to turn off division also:

     

     

     

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    According to your statement, I think you want to turn off subtotals in "Division" level from New Format Pane.

    Firstly, find "Per row level" in "Row Subtotals" and turn it on. Then select "Division" level in Series and turn off "Show subtotal" below in "Row".

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

MFelix's avatar
MFelix
Super User
4 years ago

Hi  Anonymous ,

 

For this you need to have the subtotals turn off for the leader then you get the following result:

 

This is based on level so since Division is the the first level will be the grand total so need to be turn on, then team becuase you also want to see it and leader turn off.

If you don't want total values then you need to turn off division also:

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you! Now I understood how the row fields can be selected and unselected to control subtotals! Really not intuitive UX design from Microsoft, in my opinion! Thank you very much!