M
Matt D Francis
Hi,
Need help creating a calculated field in a Pivot Table
Below is an example of my Pivot including the first two rows of data.
Average of LoS DIABETIC?
OPCS_1 Diabetic Non Diabetic
A559 13.0 9.1
A578 0.0 0.9
What I want to add for each row is a third column which displays the the
difference between the two columns so I would end up with:
Average of LoS DIABETIC
OPCS_1 Diabetic Non Diabetic DIFFERENCE
A559 13.0 9.1 3.9
A578 0.0 0.9 0.9
I can do this by adding a formula in the cell to the right of the last
column of the pivot, but this is no good as the references will be thrown
out if the Pivot changes.
So how do I add this calculation as part of the Pivot table so that it
updates with a refresh?
The field giving the figures for Diabetic & Non Diabetic columns is an
Average and this seems to be causing a problem.
Need help creating a calculated field in a Pivot Table
Below is an example of my Pivot including the first two rows of data.
Average of LoS DIABETIC?
OPCS_1 Diabetic Non Diabetic
A559 13.0 9.1
A578 0.0 0.9
What I want to add for each row is a third column which displays the the
difference between the two columns so I would end up with:
Average of LoS DIABETIC
OPCS_1 Diabetic Non Diabetic DIFFERENCE
A559 13.0 9.1 3.9
A578 0.0 0.9 0.9
I can do this by adding a formula in the cell to the right of the last
column of the pivot, but this is no good as the references will be thrown
out if the Pivot changes.
So how do I add this calculation as part of the Pivot table so that it
updates with a refresh?
The field giving the figures for Diabetic & Non Diabetic columns is an
Average and this seems to be causing a problem.