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

Category	Retailer $ - TY	Retailer $ - LY	Remaining Retailer $ - TY	Remaining Retailer $ - LY	Retailer Share TY	Retailer Share LY	Share Pt Change
4K TVs	$4,000,000	$3,750,000	$14,000,000	$13,500,000	22.2%	23.2%	(1.0)
Desktops	$750,000	$800,000	$7,500,000	$8,200,000	9.1%	8.3%	0.8
Laptops	$1,500,000	$1,250,000	$8,000,000	$8,500,000	15.8%	15.4%	0.4
Sound Systems	$2,250,000	$2,100,000	$12,000,000	$11,900,000	15.8%	16.1%	(0.3)
Video Games	$1,750,000	$1,500,000	$10,000,000	$9,750,000	14.9%	15.6%	(0.7)
Grand Total	$10,250,000	$9,400,000	$51,500,000	$51,850,000	16.6%	16.7%	(0.1)

<tbody>
</tbody>

<tbody>
</tbody>

The benchmark% is 16.6%

Category	Opp Gap Pts	Share Pt Value	Opp Gap $
4K TVs	5.6	$180,000	$1,012,146
Desktops	(7.5)	$82,500	($619,433)
Laptops	(0.8)	$95,000	($76,923)
Sound Systems	(0.8)	$142,500	($115,385)
Video Games	(1.7)	$117,500	($200,405)

<tbody>
</tbody>

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(???)