I have a simple pivot table that is averaging 7 values representing monthly
attainment. If run a simple average formula off the values i get one figure,
the pivot table average shows a different value.

Example: the seven values could be:

2/1/2008 121.04%
3/1/2008 110.54%
4/1/2008 110.23%
5/1/2008 118.90%
6/1/2008 99.89%
7/1/2008 107.66%
8/1/2008 94.59%

The average when you apply AVG() function is 108.98

The pivot table shows the average as 109.40...can anyone tell me how that's
happening? And even weirder, the same set of data is listed on two lines...
one line shows 109.40 as the average the other line shows 109.23

I have probably two strings of hair left in my head from scratching it so
much thinking over this...I'm pretty good with Excel, but this has me
stumped....

Thanks in advance...

--
Danger Mouse