Group and sort on two columns

M

Marianne

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
 
D

Doug Kanter

Marianne said:
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
Click to expand...

OK. You should do it, then. What have you tried so far?
 
Top