There are 50 employees and have a variable number of records for each
employee. I can easily subtotal by each employee however I need also to
subtotal each month for each employee. All works well until I hit one of
those employees whose 1st month total is the same as the previous employees
last month total. I have figured out how to group each employees records
together but cannot figure out how to subtotal the month within each group.
Any help is appreciated. As below, when I hit one of the records in question
my monthly totals now show up below the grand totals, then throwing the
remainder of the spreadsheet off also.

5/23/2009 5 Jane Doe1 282160
5/30/2009 5 Jane Doe1 259456
5 Total 541616
6/6/2009 6 Jane Doe1 251424
6 Total 251424
Jane Doe 1 Total 793040
5/16/2009 5 Jon Doe 14636
5/23/2009 5 Jon Doe 103154
Jon Doe Total 117790
5 Total 117790
5/16/2009 5 Jane Doe 2 104204
Jane Doe 2 Total 104204
5 Total 104204