Weighted Average in Pivot table

G

Guest

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
 
R

Rob Hick

Mischa said:
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
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - Weight Average 2
weighted average - 1 column 2
How do I calculate a weighted average and exclude the empthy cells 2
Calculate Average in pivot item 6
Calculating weighted average of Percent Change 0
Average Function that ignores zeros 10
Pivot Tables 2
weighted average in pivot excel 2007 1

Top