Turn off Year Totals in a Matrix

[mikez2605]

I'm creating a Matrix using Dynamics 365 to log the amount of hours and costs of users against projects in the past three months. I want to include the totals of the columns, however the default matrix also totals the year values, which I don't need, only the grand total.

I would like to keep the column in the date hierarchy, otherwise I will have to start creating new columns for month name, and then I have the issue of sorting the columns, and what happens at year end.

I've attached a picture of what I have so far, and I've highlighted yellow the columns I want to remove. Does anyone have any ideas?

[v-shex-msft · Accepted solution]

HI @mikez2605,

You can simply control subtotal feature at formatting-> subtotal option, please follow below gif to know detail steps.(formatting -> subtotal -> per column level)

Regards,
Xiaoxin Sheng