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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Zubair

      Can we un do the acceptance...i clicked the wrong button, your solution was prefect.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello,

       

      For some reason this link is not working. Can you please re-send?

       

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I have a Matrix that I am trying to sort the column headers in. 


        I would like to put the column headers in this order:

        1. Quote
        2. Open
        3. Pending
        4. Business Office
        5. Sold
        6. Posted

        I tried creating a new column and called it Deal Status Column and used the following:

         

        Deal Status Column = IF('Vehicle Sales'[Sales Status] = "Quote", 1, IF('Vehicle Sales'[Sales Status] = "Open", 2, IF('Vehicle Sales'[Sales Status] = "Pending", 3, IF('Vehicle Sales'[Sales Status] = "Business Office", 4, IF('Vehicle Sales'[Sales Status] = "Sold", 5, IF('Vehicle Sales'[Sales Status] = "Posted", 6))))))
         
        I then clicked on the original Deal Status in the Fields list and clicked Sort by Column and selected teh Deal Status Column and I get the following pop up:

        I'm not sure where to go from here. Any suggestions?