Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Moving Columns on Matrix

Hi All,   I know that quite some results about changing columns on Matrix, but I tried all of them and none gave me the result I expected.   I tried creating a new table and a new relationship wi...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi All,

     

    I managed to get it sorted.

    So, creating a new table with the same data, means that is case sensitive and needs to be exactly the same format from the data that comes from the server. Otherwise, it won't work.

     

    I had the newly table with the same content, but words with the first letter in capital and the rest not. 

    The original data is all in capital letters, so won't work.

     

    Also, adding the Total on the last line to get the total of the column was a great tip SamWiseOwl .

     

    Lesson learned.

     

    I hope this finds well with the rest of the community.

     

    Cheers and thank you all for your support.

     

    Fernando