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
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?