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

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi There,

 

You can drag your column fields in matrix visuals up and down to see the expected result.

 

 

Thanks & Regards,

Bhavesh

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Bhavesh,

     

     

    The columns are not seperate categories in different columns...as shown below they are retailers all contained in one data tables column.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi there,

    can you please share some screenshot for this, thanks in advance