Hi there,

I've got the following extract of my data:

Employee Qty Target Efficiency
026 60 495 12%
026 60 495 12%
026 60 495 12%
026 60 495 12%

The above target is a daily target, but the qty is what was recorded during
the day... to pivot this data, it must produce the following pivot:

Employee SumOfQty AverageOfTarget
026 240 495

Which is fine... BUT I have the following two problems:
1. When adding a calculated field to calculate the efficiency it
calculates 12% (60/495) and not 48%.
2. When I put the SumOfEfficiency in my pivot, it's correct per day (48%) -
is there a way to calculate the grand total as an average?

Pse help with either of the above two...

Thank you!