Weighted Average Calculations for Pivot Tables

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
 

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

Top