Showing Column Grand totals in Matrix with out Sub-totals

[Anonymous]

I have a requirement where I need to have a matrix with 6 dimensions on rows, but only showing the sub-total at level 3 (this is for formatting purposes/requirements), with the Month-->Week on Columns.  I need to be able to show the Column grand total, i.e. just the total for whole year, but without showing the subtotals for every month in between.   I need to preserve the grouping format of Month--> Week on columns.  Does anyone know a way to achieve this?  I need to use the matrix, as I need to have the row and column groupings so a plain table is out.  I found this thread: 

https://community.powerbi.com/t5/Desktop/show-grand-totals-top-bottom-of-matrix/td-p/370909

 But I was hoping that since then someone has figured out a good solution for this.  Thanks! 

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

I'd like to suggest you refer the following link. Hope it helps.

https://community.powerbi.com/t5/Desktop/Removing-Row-Sub-Totals-from-Matrix-and-Leaving-the-Row-Grand/m-p/457772

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Ok, it looks like the confusion was mine - when I was originally setting this up, I couldn't find the "per column level" under sub-totals.  Once I set this up, and set it only at the top level the grand totals are displaying at the end.   Thanks All!

[Anonymous]

HI - Thanks for the response, I saw this post as well, but it had to do with Row Sub Totals not Column sub-totals. I've already done the row-by-row sliders to achieve the formatting I need.  Unless you meant the other part about creating additional measures? Would this work for the columns then, instead of the rows? 

[Greg_Deckler]

See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...