Sorting the values of a column in a matrix

[Anonymous]

Hello,

I made a matrix in which the column y is divided by proceeds and total costs. So, the distinction is made by the matrix. Now I think it is sorting on the alphabet.  However, I'd like to show first total costs and then proceeds. I don't know how to sort this because these values are actually one column in the data. 

Thank you in advance.

Regards,

Tom

[Bipin-Lala]

Hi @Anonymous,

I just wrote a solution for a very similar question a day ago. Try referring to this post.

Let me know if this helps, or if you have any other specific requirements!

[Anonymous · Accepted solution]

Hi @Bipin-Lala 

Thank you for your answer.

I eventually solved it on a different way:

I made a conditional column, with total costs = 1, proceeds = 2 (called it ranks).

Then I made this ranks column a number type. 

Then I sorted the table on the basis of the ranks column. This causes that the initally column also got sorted in the right way.

When I tried again in the matrix, I got the sequence I wanted.

Regards,
Tom