Excel Create custom Formula within Pivot Table (average)

Hi all!

I am using Excel 2007 and I have data that i'm trying to look at thru a pivot table. I can create the pivot table but then I need to create a new field that will create an average instead of a sum.

The reason i need an average is becase the data is actually Scores given by customers to rate our technicians and I just need the average.

I thought all i would need to do is select PivotTable Tools-> Options -> Tools -> Formulas and click on Calculated Fields and imput the formula i want (example: Average). But that seems not to work either.

Maybe a pivot table isn't the right thing to use, any suggestions would be GREATLY appriciated.

I have attached an example file of what I am trying to do.

Pivot tables do averages without needing to divide sum by count -
Right-click 'Sum of Statusing'
Field Settings
In the list box select 'Average'
OK

Average doesn't include blanks either, which solves your other problem.

hth