Help with pivot chart calculated field

Hi,
I'm having a challenge here.
I have the following data in an excel sheet. The data comes from an
access database tand hence changes daily.

Name TeamName Volume Shipped Hrs worked Shipped per Hr
Jack Frank 3 1 3
Rose Frank 6 3 2
Barbary Frank 7 2. 2.8
Sam Harry 5 2 2.5
Peter Harry 8 4 2


The shipped per hour field is Volume Shipped/Hrs worked.
I would like to calculate the average Shipped per Hr for each team. For
eaxample for TeamName-Frank, the average Shipped per Hr would be
(3+6+7)/(1+3+2.5).

And Frank can have 4 people working under him tomorrow instead of
three. So it's dynamic.
I have all the fields in a pivot table and a pivot chart with sum of
Volume Shipped in the data area
I was trying to creat a calculated field that would calculate the
average shipped per hour for each team, in vain.
I was trying something like SUM[Volume Shipped]/SUM[Hrs worked] in the
calculated field formula in th pivot chart. I guess it's kinda stupid
and is not working.

Can anyone help me solve my problem?

Thanks a lot for your help...
Pragv

I do not understand your data.
You say the calculation for Frank's team should be (3+6+7)/(1+3+2.5) but Franks team does not have any hours value of 2.5, did you mean 2?
Every row except row 3 has a value for shipped per hour equal to volume shipped divided by hours worked... Is there some reason for that different value?

Assuming the above are just typos, a simple pivot table with either a calculated field of volume shipped / hrs worked or an extra column in the data with the same calculation seemed to work ok in a pivot table.

regards