Pivot Table Ratio

I have the following setup in my work sheet:

Column A- Employee Name
Column B- Office Location
Column C- Review Type
Column D- Initial Points
Column E- Bonus Points
Column F- Negative Points
Column G- Points Earned, which sums columns D-F and is written as Sum(D2,E2,F2) for each row housing data.

I created a column H called Points Ratio, which basically divides column F by column D. Therefore, for each row housing data one can see a percentage, i.e. 90%, 65%, 88%, etc.

I also created a pivot table as followed:

Page= Employee Name
Row= Office Location
Column= Review Type
Data= Points Earned, which is summarized as an average.

The problem I am having is when I fire away and querry my results are averaging an average. However, I desire a cummulative or weighted average. For example, if:

Initial Points- 100, Earned Points- 70, Points Ratio= 70%
Initial Points- 270, Earned Points- 95, Points Ratio= 35%
Initial Points- 150, Earned Points- 85, Points Ratio= 57%

The pivot table computes an average as 54%, (70%+35%+57%)/3. However, the cummulative or weighted average I'm trying to get is 48%, (70+95+85)/(100+270+150).

Any help is appreciated....

Hi,
could you post a sample of your data ? This would help us see what you need.
Thx

Sorry, attached is a sample of what I have.

Insert a calculated field by putting the required formula of dividing points earned/ initial points. that gives you the required %.

Glad to help and thx for the feedback