Totals in Pivot Charts

[xxthegiantxx]

Column Header	1	2
Row Data	a	b
subtotal	1 X a	2 X b

<tbody>
</tbody>

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