I have a pivot table that displays sums and an average of data relating to staff.

e.g.

Staff Name Average of line rental Sum of total cost 1 Sum of total cost 2 Total of line rental and Cost 2

Bob 12 58 60 ?


I want to add a calculated field into the pivot table so I can add the 'average of line rental' and the 'sum of total cost 2' displayed values together as a new totalised field.

I have tried various formula in the calculated field, but it does not treat the average field as the displayed value 12. Instead it totalises the raw data that has been averaged to produce 12 as a result.

Excel seems to ignore the fact that we already have an average in place.

Is there are way to add the average value 12 to the cost 2 value of 60 within the pivot table?

Thanks in advance.

Craig