Subtotal and then subtotal again

I have a table report and have set it to sort and group on my users' names and that works great.  It summarizes the data for each user and gives me a subtotal for each user and the total for all users at the bottom. 
I would like to get some greater granularity, and add a sort and group by city for each user.  I would like the report to have a subtotal for each person in each city and then the subtotal for each person in all cities he or she has.
When I add the second "sort and group by", I lose the total per person.  Is there another way to do this so that I can have both subtotals?



------------------------------
Chris Sipes
------------------------------