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.