Grouped Report Total

[RedTagg]

Hello, I have a grouped report setup so that it looks like this:
---------------------------------
Header
-------------Titles--------------
Person Name | Hours | Cost
--------------Data---------------
Person Name | Hours | Cost
---------------------------------
Footer
---------------------------------
I want to know how I can add a text box and what I have to put in it to give me the totals for all of the costs for that one person. All I get is a list of ther hour and costs
like this;

Name
Hours Cost
1 £3.00
2 £6.00
Name
Hours Cost
1 £3.00
2 £6.00

But I need to add the totals if you see what I mean. All I seem to get with totals is this:

Name
Hours Cost
1 £3.00
Total £3.00
2 £6.00
Total £6.00
Name
Hours Cost
1 £3.00
Total £3.00

etc

Can anyone please help, because I have no idea how to add up the totals of all of the cost fields as some have one and others have lots, or even where to put the total text box

Thanks

 

[nrugado]

You should add a grouping level for the "persons" primary key (employee id). Create a field that has this formula in the control source property =sum([cost]) and place this in the footer of that persons primary key footer.