Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Custom Total in Matrix

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 ...
matrix
total
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.