Totals in Pivot Charts

[xxthegiantxx]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Column Header[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Row Data[/TD]
[TD]a[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]subtotal[/TD]
[TD]1 X a[/TD]
[TD]2 X b[/TD]
[/TR]
</tbody>[/TABLE]

I am trying to figure out if i can get the subtotal to show a calculation of the column header and the row data so as to show the subtotals calculating like the table above. I found information on calculated fields but that says it can only show the sum where i want to be able to show the product of the two.

 

[SpillerBD]

You would have to link those results to a calculation. You can use GETPIVOTDATA and then a HLOOKUP or INDEX or... to provide the multiplication factor