Sorting Matrix Table Values

[dstramilov]

In Matix visual, how can keep "Account Type" sorted not alphabeticly, but based on GL account #?

I tried sorting based on column, but no luck. 

In the example below is Quickbooksonline out of the box model, I just selected "Account Type".

[SamLester · Accepted solution]

You can use the "Sort By Column" functionality to accomplish this. Click on the Data tab, highlight the row, select the Modeling tab, then "Sort By Column". This will allow you to sort by a different column, such as Account Number.

Thanks,
Sam Lester (MSFT)

[jhauff77060]

Shouldn't the instructions read " ... Click on the Data tab, highlight the row column ..."?

[Anonymous]

hello!

is there a way to have a 2-step sorting scheme?

I have a table and the first filter has to be on a measure I created, then considering that many of that is 100%, I would like to sort the table according to another variable, which is not a measure.

Thanks in advance for helping.

Regards,

Andrea