Excel Pivot Table Failing to Calculate an Average on a Calculated Field

[NukedWhale]

Hello,

Please see the attached worksheet for an example of the error. There is a worksheet with source data and a worksheet with the pivot table.

My field is set to calculate averages, but it's clearly calculating sums. Any ideas? Am I totally missing something?

[Paul_Hossler]

1. Your data has 2007 in twice.
2. Average is the average for the row (=Year)

So if I make the second 2007 into 2010, the average on the 2007 line = 5, or (10 - 5) / 1 since there is only 1 value being averaged

if you want the average of the yearly averages, I'd put a =AVERAGE( ) into the sheet

Paul

[NukedWhale]

I've attached a better example of my error.

I have added a field in the database that's calculated on actual-budget
I have added a calculated field to the pivot table that's calculated on actual-budget

Both fields are added to the pivot table and are set to calculate averages. However, I'm getting two different answers. Any ideas as to why?

Is this a known Excel bug?

[NukedWhale]

Bump. Sorry to be a bother. :/

[Aussiebear]

Have a look at your data. As Paul kindly pointed out you have 2007 data in twice in the data set.