Need Sub Total

Question

Hi All,

I have to pull out a report with  the following format from SQL server 2008:

Department1    John  Smith   $10.00
                         Matt  Doe      $20.00
Total                 2                   $30.00
Department2    Michael Dell   $15.00
Total                1                    $15.00
Total                3                    $45.00

How can I get the subtotal inserted?

Thank you in advance for your time and help.

ellen