Calculating Opportunity Gap within Pivot Table

[Fantoi]

Hi,

I've been struggling with this for a while, but I am trying to do a Opportunity Gap calculation within the pivot table.
Below is how i have my data laid out. I am able to calculate $% Change, Retailer's Share (TY/LY) and the Share Point Change all within the Calculated Field portion. But how am I able to calculate out the Opportunity Gap?

Equation:
Opp Gap Pts= (% Share - Benchmark%)*100
Share Pt Value= Current Total Sales/100
Opp Gap $ = Opp Gap Pts * Share Pt Value
- I would like to get to this calculation (in bold) in the Pivot Table[TABLE="width: 711"]
<tbody>[TR]
[TD="align: center"]Category[/TD]
[TD="align: center"]Retailer $ - TY[/TD]
[TD="align: center"]Retailer $ - LY[/TD]
[TD="align: center"]Remaining Retailer $ - TY[/TD]
[TD="align: center"]Remaining Retailer $ - LY[/TD]
[TD="align: center"] Retailer Share TY[/TD]
[TD="align: center"] Retailer Share LY[/TD]
[TD="align: center"] Share Pt Change[/TD]
[/TR]
[TR]
[TD]4K TVs[/TD]
[TD="align: right"]$4,000,000[/TD]
[TD="align: right"]$3,750,000[/TD]
[TD="align: right"]$14,000,000[/TD]
[TD="align: right"]$13,500,000[/TD]
[TD="align: right"]22.2%[/TD]
[TD="align: right"]23.2%[/TD]
[TD="align: right"](1.0)[/TD]
[/TR]
[TR]
[TD]Desktops[/TD]
[TD="align: right"]$750,000[/TD]
[TD="align: right"]$800,000[/TD]
[TD="align: right"]$7,500,000[/TD]
[TD="align: right"]$8,200,000[/TD]
[TD="align: right"]9.1%[/TD]
[TD="align: right"]8.3%[/TD]
[TD="align: right"]0.8[/TD]
[/TR]
[TR]
[TD]Laptops[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$1,250,000[/TD]
[TD="align: right"]$8,000,000[/TD]
[TD="align: right"]$8,500,000[/TD]
[TD="align: right"]15.8%[/TD]
[TD="align: right"]15.4%[/TD]
[TD="align: right"]0.4[/TD]
[/TR]
[TR]
[TD]Sound Systems[/TD]
[TD="align: right"]$2,250,000[/TD]
[TD="align: right"]$2,100,000[/TD]
[TD="align: right"]$12,000,000[/TD]
[TD="align: right"]$11,900,000[/TD]
[TD="align: right"]15.8%[/TD]
[TD="align: right"]16.1%[/TD]
[TD="align: right"](0.3)[/TD]
[/TR]
[TR]
[TD]Video Games[/TD]
[TD="align: right"]$1,750,000[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$10,000,000[/TD]
[TD="align: right"]$9,750,000[/TD]
[TD="align: right"]14.9%[/TD]
[TD="align: right"]15.6%[/TD]
[TD="align: right"](0.7)[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$10,250,000[/TD]
[TD="align: right"]$9,400,000[/TD]
[TD="align: right"]$51,500,000[/TD]
[TD="align: right"]$51,850,000[/TD]
[TD="align: right"]16.6%[/TD]
[TD="align: right"]16.7%[/TD]
[TD="align: right"](0.1)[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 483"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The benchmark% is 16.6%

[TABLE="width: 383"]
<tbody>[TR]
[TD="align: center"]Category[/TD]
[TD="align: center"]Opp Gap Pts[/TD]
[TD="align: center"]Share Pt Value[/TD]
[TD="align: center"]Opp Gap $[/TD]
[/TR]
[TR]
[TD]4K TVs[/TD]
[TD="align: right"]5.6[/TD]
[TD="align: right"]$180,000[/TD]
[TD="align: right"]$1,012,146[/TD]
[/TR]
[TR]
[TD]Desktops[/TD]
[TD="align: right"](7.5)[/TD]
[TD="align: right"]$82,500[/TD]
[TD="align: right"]($619,433)[/TD]
[/TR]
[TR]
[TD]Laptops[/TD]
[TD="align: right"](0.8)[/TD]
[TD="align: right"]$95,000[/TD]
[TD="align: right"]($76,923)[/TD]
[/TR]
[TR]
[TD]Sound Systems[/TD]
[TD="align: right"](0.8)[/TD]
[TD="align: right"]$142,500[/TD]
[TD="align: right"]($115,385)[/TD]
[/TR]
[TR]
[TD]Video Games[/TD]
[TD="align: right"](1.7)[/TD]
[TD="align: right"]$117,500[/TD]
[TD="align: right"]($200,405)[/TD]
[/TR]
</tbody>[/TABLE]

EX of calculation: Desktops Opp Gap $
Opp Gap Pts= (9.1%-16.6%)*100
Share Pt Value= ($750,000+$7,500,000)/100
Opp Gap $= [(9.1%-16.6%)*100]*[($750,000+$7,500,000)/100]



Any help is welcomed, whether its restructuring the data or having two pivots(???)