Custom Total in Matrix

[Anonymous]

Hi everyone,

I'm struggling with Totals in Matrix. At the moment I have Total values for every G.

Is it possible to have cumulative totals?

• 1st Total = Total of G1
• 2nd Total = 1st Total + Total of G2
• 3rd Total = 2nd Total + Total of G3

Is it possible to change the names of Totals for G? (example: "Total G1", "Total G1+G2", etc)

Thanks in advance.

Regards,

Jagoda

[Anonymous]

is there any date column or index column in your dataset?

Desired Ouput =

var CurrentDateValue = max('Date'[DateValue])

return

CALCULATE( [measure], All('Date'[DateValue]), 'Date'[DateValue] <= CurrentDateValue )

Where date is table name. change it with your table name.

[Measure] is just sum of column.

and its not possible to change row subtotal for particular category.

You can rename that total with any other text but dynamical subtotal renaming is not possible.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Thanks for your answer.

I still don't understand how it can help to resolve my problem with custom subtotal values. Could you please elaborate?

[Anonymous]

you can change the subtotal name by clicking on matrix visual then click on formatting then on subtotal.

Subtotal name is static not dynamic.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.