Removing grand total of column subtotals

[Anonymous]

Hello Community,

I have a matrix visual where I want the column subtotal for each year, but, I'm also getting the total sum of amount for all the years which I want to avoid from my visual. Is there a way to do it? If I turn off the column subtotal under format section, I cannot see the column subtotal for respective years. I just want to avoid the total sum of the years combined (The one marked in yellow). Below is a screenshot of my sample dataset. 

[MattAllington · Accepted solution]

Take a look at the bottom of my article here https://exceleratorbi.com.au/build-a-pl-with-power-bi/

you will have to test it out, but I suspect it is the same solution.