F
ffrazz
How does one implement weighted averages in pivot tables.
Assume
Bonds Interest Rate
100,000 .06
200,000 .04
800,000 .10
Weighted Average Interest Rate is .0927
(I normally do this using sumproduct(col a,col b)/sum(col
a)
I would like to be able to perform this in a pivot table
with the weighted average calc being a grand total. You
can see how this can be useful and expanded once the
basics are found. Any ideas.
ffrazz
Assume
Bonds Interest Rate
100,000 .06
200,000 .04
800,000 .10
Weighted Average Interest Rate is .0927
(I normally do this using sumproduct(col a,col b)/sum(col
a)
I would like to be able to perform this in a pivot table
with the weighted average calc being a grand total. You
can see how this can be useful and expanded once the
basics are found. Any ideas.
ffrazz