Forum Discussion
Sort / Arrange Matrix Values
I have a matrix table , and I would like to reaarange the values based on typical flow
Correct Order would be DISP,ENRT,ARRVD,RETRN, and CMPLT
Would I need to create another table with my header value and a number value ? how do i then sort by that table ?
Thanks
Hi bcampbell,
I'm assuming that the headers on the table are a category on your data table, based on that for making a custom sort the best option is to create a new table with the following format:
Cat ID
DISP 1 ENRT 2 ARRVD 3 RETRN 4 CMPLT 5 Sort the column CAT by the column ID and then make a relationship to the first table.
Lastly use the value on the table above for your matrix and the values should be in order.
As you can see on below the first table uses columns from a single table and the order is alphabetic, on the second one using the sorting table it's on the order you need.
Regards,
MFelix
5 Replies
Hi bcampbell,
I'm assuming that the headers on the table are a category on your data table, based on that for making a custom sort the best option is to create a new table with the following format:
Cat ID
DISP 1 ENRT 2 ARRVD 3 RETRN 4 CMPLT 5 Sort the column CAT by the column ID and then make a relationship to the first table.
Lastly use the value on the table above for your matrix and the values should be in order.
As you can see on below the first table uses columns from a single table and the order is alphabetic, on the second one using the sorting table it's on the order you need.
Regards,
MFelix
