Sorting in Martix

[Zion]

Hello!

I have a Martix with Rows grouped on Location and Colums grouped on AgeGroup(Adults, Youths, Teens, Tweens etc.,). I want the Rows (Location) to be sorted based on another column in the table called LocationOrder and in the same way the Columns (AgeGroup) to be sorted on the AgeGoupOrder field in the table. The 'Order' fields are only for sorting and must not be displayed. I'm not sure how to do this. Any help would be much appreciated. Thanks.

[Anonymous]

Start by selecting the Location column in the fields list, then go to the Modeling tab, then click Sort by Column, and choose the LocationOrder column.

[Anonymous · Accepted solution]

[Zion]

@Anonymousthanks. It works!