Forum Discussion
Matrix Column Head Order
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
Hi,
I had a similar issue.
interestingly it is working for one Matrix and not for Another.
I have recheck each and everything.
Any suggestions
Anonymous
There seems to be a bug in the order system. The way around it is to make sure that you have numbers as numbers, text as text, and dates as dates. Then make sure that you click on the field list on the right side. click on the field you want to be sorted. Then click off the field, but onto another field in the same table of the field list.
Then click back on the field and then the modeling should show up as sort by column. When it does, choose the field you want to sort the field by. So for example maybe you want to sort your organization by date. Click on org then off of org then back on to org. Then int he modeling tab at the top, the Sort by Column button will be available. Click on that and then chose date. This will sort your org by date. Hope this helps.