Originally posted by duky
I was trying to set up a calculation in pivot table to calc the weighted Average of LTV. The calculation should be Sum(LTV*Loan Amount)/sum(Loan Amount). Is there anybody can help me. Thx
I had a similar problem, and gave up trying to use the "% of Column" percentage in a calculated field. My solution was to write VBA code that was initiated through a commmand button once the user had designed the pivot table. The VBA code forced inclusion of the "% of Column" Data field. A row was added on the worksheet below the pivot table results, which used array formulas (using the "% of Column" row data range) to calculate the weighted averages.