Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

TRICKY Matrix Table Text and Total Issue

Hi Experts

 

Is it possible to show the body of the data as Text Values and The Total as Numbers in a Matrix Table. As shown in the excel table below..

 

Need Help
  • netanel's avatar
    netanel
    4 years ago

    HI Anonymous 

    Familiar problem,

    This is possible if you have a value column as text and a value column as a number,
    What will happen is that the matrix will open two steps to one column
    And really the total will only sum up the numbers

     

    Although for you the total is presented as an incorrect sum

2 Replies

  • netanel's avatar
    netanel
    Post Prodigy
    4 years ago

    HI Anonymous 

    Familiar problem,

    This is possible if you have a value column as text and a value column as a number,
    What will happen is that the matrix will open two steps to one column
    And really the total will only sum up the numbers

     

    Although for you the total is presented as an incorrect sum

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, Anonymous 

    It's up to your table struture.

    Can you share your sample data for further research?

     

    Best Regards,
    Community Support Team _ Eason