Sorting in Martix

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.