Calculated Field in A Pivot

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top