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 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

 

 

matrix
total

3 Replies

  • 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.