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