how to sort a matrix report on two columns

[patelwork]

hi,

how can we sort the matrix report with two colummns while the both columns belongs to different groups (as we know each group should have at least one order through property).

the order by clause in the query is not working...