Right click on the date field in your pivot table. Select Group and Show
Detail and then Group. Click on Months (and maybe Tears) and then OK.

Hope this helps
Rowan

filky wrote:
I have a set of data in columns with an entry for a date in each row. I
would like to use a pivot table to calculate the totals in the rows by
month as oppose to by day. How do I roll up a dd/mm/yy format to
subtotal the months?

Regards

Filky