Group and sort on two columns
I want to group by number then sort by amount descending.
sample:
111111 50.00
222222 100.00
111111 50.00
222222 50.00
I want it to sort this way:
222222 100.00
222222 50.00
222222 total 150.00
111111 50.00
111111 50.00
111111 total 100.00
|