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 Team column. Couldn't sort it out...

 

 

--> I would expect no subtotals for Division based on the settings "apply settings to --> row level --> team"

 

Thanks for your support all!

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.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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!

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    Anonymous If I understood what you want so you need to apply the subtotal only to the division series and not dot the others + grand total.