No, I need the periods to be summed as normal but the end 'Grand Total'
column inserted by the pivot table to show as an average rather than a sum.

Regards

"Michael" wrote:

if you right click the data in the pivot table and choose field settings you
can change the sum to average. Is this what you want?

"Co-op Bank" wrote:

Hello,

I have a list of data with three columns, these are 'Period', 'Area' and
'Cost'.

I want to pivot to show the area's listed down vertically, the period
horizontally across and the 'Grand Total' inserted in the pivot table to give
an average of the periods instead of the sum. Is this possible?

Please advise, much appreciated.

Brian Taylor
Manchester, England.