Matrix - Remove column Grand Total but keep Sub Total

[JimJim]

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 🙂

[PijushRoy · Accepted solution]

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]

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