Hi All

I have a pivot table which I want to break the data down into month and
year. The data in the main spreadsheet is in day, month and year. So far I
have used the Month (field) and year (field) to translate the month data
within the original source file and then run the pivot table.

Is it possible to do this calculation within the Pivot table - I have tried
the inserting a calculated field but this will not allow me to put the drop
column fields here -

Any help greatly appreciated

Cheers Rexmann

PS I am using Excel 2003