Forum Discussion

mikez2605's avatar
mikez2605
Regular Visitor
8 years ago
Solved

Turn off Matrix Year Total

I'm creating a Matrix using Dynamics 365 data, which shows time and expenses for a user, against each project, for the past three months. I want to show the grand total of the matrix, however would l...
  • shebr's avatar
    shebr
    8 years ago

    Hi mikez2605

     

    See image below.

     

    You can see I have the same option as you in the tob tabe, and not in the second tabe.

     

    Under the subtotals menu you have a an option 'Per column level'. Switch the relevant subtotal off and switch th per column level on and one of the groups.

     

    Try and let me know how you get on.

     

    Thanks

     

    shebr

     

shebr's avatar
shebr
Resolver III
8 years ago

Hi mikez2605

 

See image below.

 

You can see I have the same option as you in the tob tabe, and not in the second tabe.

 

Under the subtotals menu you have a an option 'Per column level'. Switch the relevant subtotal off and switch th per column level on and one of the groups.

 

Try and let me know how you get on.

 

Thanks

 

shebr

 

  • mikez2605's avatar
    mikez2605
    Regular Visitor
    8 years ago

    Amazing, that worked perfectly! Didn't even realise those extra options exist!

     

    Thank you very much :)