How can I calculate a weighted average in a Pivot Table?

I'm looking for advice on how to best calculate a weighted average within a pivot table. In my attached spreadsheet, my pivot table gives me the normal average of 4.62% for APR's. I calcualted a weighted average of 4.11 in cell Z2 of the data tab by using the sumproduct formula. I'd like to be able to have the 4.11 number show in my pivot table under the grand total average for APR. Any suggestions are appreciated. Thanks

Put this in D8, but, do I thinking the task too simple to give this answer? Please let me know

Please Login or Register  to view this content.