Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Matrix Subtotals

Hi all,   I have a matrix as follows:    I am trying to achieve both column and row totals of 100%. As you can see, this works correctly for the columns but for each row it sums the values ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

Did your row field and the column field are from the same table? Can you provide some sample data so that can provide more suggestion for you.

 

Best Regards!

Yolo Zhu

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous,

     

    Thanks for your response. All data is from the same table:

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous 

      You can try the following measure

      Measure =
SUMX ( VALUES ( Times[name] ), [% Summary Total] )

      Best Regards!

      Yolo Zhu

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

         

        Produced the error SUMX can't work with values of type String.

         

        I have tried two measures that produce work for either columns totalling 100 or rows:

         

         

        Hoping to combine them to have both the column and row overall totals = 100 cheers