Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Sort Column Header in Matrix Table

Hi Experts   I am trying to sort column Headers in a Matrix Table.....so they are in number order increasing...unable to do this action???   The image shows 1 then 10 then 11 and not item 2 t...
Need Help
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

as the field type is text it sorts alphabetically
you can either:

1) use custom sort (you would need to create numeric rank column first)

2) reformat the data so alphabetical order would meet your needs, e.g. changing format number to 01, 02, ... , 10, 11 etc.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

     

    How would you create a numeric rank column...happy to learn...i tried adding an index column did not work??

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Thanks Zubiar...

         

        got half way their missed the last steps out.....excellent aritcle