Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: calculation in Excel pivot table

    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

  2. #2
    Join Date
    Dec 2003
    Posts
    1

    Re: calculation in Excel pivot table

    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.

    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •