Hi,

You haven't told us what your base calculation is. With the dummy data you
provided I just change the base calculation to average and get exactly the
expected result in the Grand Total column.
I tested in 2003 and 2007.

Are A, B, and C different fields or different elements of a column field?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Jeff" wrote:

I have created a formula in a Pivot Table to average A,B and C.
I have tried the following with the same results:
=AVERAGE(A,B,C)
=Sum(A,B,C)/Count(A,B,C)

A B C Should be Formula
1 0.75 1 0.9167 91.67%
(blank) 0.75 1 0.875 58.33%
1 0.5 1 0.8333 83.33%
1 0.5 0 0.5 50.00%
1 1 1 1 100.00%
(blank) 1 1 1 66.67%
1 1 1 1 100.00%

Any other suggestions?

Thanks,