Calculated Fields in Pivot Table

[KarlSch]

Hi

I am trying to calculated a weigted average age in a pivot table.

My input data looks something like this:

Age Type Count
30 1 10
30 2 1
30 3 4
40 1 20
40 2 5
40 3 10


And I want a pivot table that lists:

Type Average Age
1 sumproduct(Age,Count)/sum(Count) = 36.67
2 "
3 "


Anyone know how I can achieve this?


Thanks
Karl

 

[RoryA]

You would have to add a column to the data source that multiplies the two columns together. Then in the table create a calculated field that divides that new column by the count column.