Help with pivot chart calculated field

G

gvpradeepkumar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculated Fields 4
Pivot Chart- 2 unrelated series on 1 chart 4
Pivot Table Subtotals - Calculated field subtotal incorrect 3
Pivot Chart Help! 0
Calculating costs 0
Calculate total amt due on an invoice. 9
pivot table calculated field 1
calculate hours using start time & end time, excluding weekends 5

Top