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.
<tbody>
</tbody>
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.
<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>