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.