Group and sort on two columns

[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

[Doug Kanter]

"Marianne" <Marianne@discussions.microsoft.com> wrote in message
news:B6E29E0C-56E1-4384-AB50-71D9A2D09C71@microsoft.com...
>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

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