Is there a way to subtotal/total column values using alternating columns

[AaronToth]

We have a matrix that has 2 columns (Amount and Quanity) and the matrix is broken up by Year.  So the matrix would look like this

Amount/Quantity - Amount/Quantity - Amount/Quantity (with headers above 2005, 2006 and 2007)

Question:  Is it possible to subtotal/total to the right for just one column (i.e. Amount).  Right now if you turn the sub-total/total on, it will add all values across the grid.  Can we separate these?

This is what we would like to have

Thanks,
Aaron

[Greg_Deckler · Accepted solution]

@AaronToth There is a way but it is not exactly pretty. You can shrink the unwanted columns or you can do this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

[Greg_Deckler · Accepted solution]

@AaronToth There is a way but it is not exactly pretty. You can shrink the unwanted columns or you can do this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

[AaronToth · Accepted solution]

Thanks @Greg_Deckler 

Aaron Toth