Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Matrix Column Head Order

  Is there a way to change the order of the column heads in a Matrix table.  Currently it displays in alphabetical ascending order.  I would like to reverse that if possible.  A prefered option ...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    We can do that with following steps. Assuming we have a table like below. We can add a reverse index.

     

    Close and apply Query Editor, select the Type column and make it sort by column of Index.

     

    Now the order of the column heads will follow the Index.

     

    If you want to put it in a custom order, you can customize the index yourself. For example, you can create a conditional column in Query Editor.

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Anonymous

 

We can do that with following steps. Assuming we have a table like below. We can add a reverse index.

 

Close and apply Query Editor, select the Type column and make it sort by column of Index.

 

Now the order of the column heads will follow the Index.

 

If you want to put it in a custom order, you can customize the index yourself. For example, you can create a conditional column in Query Editor.

 

Best Regards,

Herbert

yatinpurohit's avatar
yatinpurohit
Helper I
8 years ago

Thanks. This worked out perfectly.