How to sort based on two columns?

[#1]

How to sort based on two columns?

1 priority is the first column, than 2 priority is the second column????

[sunny_talwar]

Is this numeric sorting or text??? Would you be able to share a sample?

[#3]

First I need to order by date, and then in each day sort by its numeric value . All Sortings are descending:

example:

This data:

14/7 -40

13/7  -30

13/7  -20

13/7  -25

12/7  -100

should be sorted to:

14/7 -40

13/7 -20

13/7 -25

13/7 -30

12/7 -100

[sunny_talwar]

How about something like this as your sort order expression:

Date*100000 - NumericValue