Weighted Average in Pivot table
 

Hi all,

just ran into a problem after looking at the average of a pivot table and
finding the result not logical. Is it possible to do a weighted average
calculation in a pivot table? It currently takes the average of all the
averages and it obviously doesn't make any sense.

thanks in advance,
mischa

Weighted Average in Pivot table
 

Mischa wrote:
Hi all,

just ran into a problem after looking at the average of a pivot table and
finding the result not logical. Is it possible to do a weighted average
calculation in a pivot table? It currently takes the average of all the
averages and it obviously doesn't make any sense.

thanks in advance,
mischa

nope - pivot tables are quite simple in the calculations they will
allow you to do. You can't do a weighted average. You could do it
'manually' by displaying the value to average along side the weighting
in the pivot table and then put a formula in a column next to the pivot
table and calculate the average of that.