Pivot Tables - Subtracting Subtotal columns

[KOsmond]

I have an issue with a pivot table whereby I need to use the subtotal columns in a calculation. A sample of the data is attached

Basically calculation needs to be 13NC Total + 13NP Total - 4OC Total -4OP Total.

The difference between in calculated fields doesnt work.

Any suggestions much appreciated.

Sum of Annual Column Labels 13NC 13NC Total 13NP 13NP Total 4OC 4OC Total 4OP 4OP Total Grand Total Row Labels 4514 13 (e) i 13 (g) 13 (h) 13 (k)I A B 13 (m) 13.(q) ATO 13 (a) 13 (e) i 13 (f) 13 (g) 13 13 (o) (ii) b 13 (s) 4002 4005 4006 4007 4009 4203 4205 4206 4209 4217 4218 4221 4222 4224 4225 4226 4239 4241 4242 4247 4247.1 4504 4538 4539 4716 4735 4741 4742 4745 4748 4900 4008 4012 4013 4014 4015 4018 4019 4020 4021 4022 4201 4213 4220 4223 4225 4227 4241 4242 4246 4506 4509 4513 4532 4537 4714 4716 4718 4734 4735 4736 4743 4746 4901 10001 96.20 57.20 153.40 1,232.40 1,232.40 1,385.80 10004 24.80 24.80 988.00 813.80 1,205.10 96.20 57.20 3,160.30 122.48 122.48 1,440.31 790.40 1,201.41 3,432.11 6,739.69 10006 623.06 623.06 988.00 96.20 57.20 1,141.40 623.06 68.80 691.86 1,440.31 1,440.31 3,896.63 10008 988.00 96.20 57.20 1,141.40 1,232.40 1,440.31 2,672.71 3,814.11 10010 988.00 96.20 57.20 1,141.40 1,440.31 1,440.31 2,581.71 10012 988.00 1,205.10 96.20 57.20 2,346.50 24.64 24.64 1,089.76 1,676.99 1,040.00 1,976.00 5,782.76 8,153.90 10014 96.20 57.20 153.40 2,464.80 2,464.80 2,618.20 10015 700.00 700.00 988.00 96.20 57.20 1,141.40 741.58 741.58 1,440.31 1,440.31 4,023.29 <colgroup><col style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;" width="98"> <col style="width: 86pt; mso-width-source: userset; mso-width-alt: 4169;" width="114"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="2" width="64"> <col style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" width="68"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;" width="73"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" width="71"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="2" width="64"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;" width="74"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <col style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;" width="73"> <col style="width: 34pt; mso-width-source: userset; mso-width-alt: 1645;" width="45"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" span="3" width="46"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;" width="35"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" span="2" width="46"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;" width="39"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;" width="39"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" span="2" width="46"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" width="49"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;" span="2" width="39"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="3" width="57"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;" width="39"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" width="71"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="5" width="57"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="4" width="64"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" width="71"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="2" width="57"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="2" width="64"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;" width="39"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="2" width="57"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="2" width="57"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;" width="39"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="4" width="57"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="2" width="64"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" width="71"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" width="71"> <tbody> </tbody>

<tbody>
</tbody>