Forum Discussion

JimJim's avatar
JimJim
Responsive Resident
4 years ago
Solved

Matrix - Remove column Grand Total but keep Sub Total

Hi Guys,

 

How do I remove the column grand total whilst keeping the sub total? Here is my matrix:

 

 

It looks like I can't remove grand total without also removing sub total.

 

 

Thanks 🙂

Need Help
  • PijushRoy's avatar
    PijushRoy
    4 years ago

    Hi JimJim 

     

    You can hide the column as below image

     

    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos

     

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    4 years ago

    Hi JimJim 

     

    You can hide the column as below image

     

    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos

     

    • JimJim's avatar
      JimJim
      Responsive Resident
      4 years ago

      Thank you, it does seem strange that Microsoft don't allow us to simply turn it off. But this hack will do the job 🙂