If you have dates as one of your fields, look at the group capability of the
pivot table. You can group on year and month.

--
Regards,
Tom Ogilvy

"andreww" wrote in message
...
Hi - I have a pivot report which is basically date_invoice_paid by
category_of_invoice with sales_value as the data item. I want to have
year(date_invoice_paid) and within that month(date_invoice_paid). I could
make another column in the excel sheet but wanted to know if there was
some
way I could formularise it programtaically/otherwise.

Cheers

Andrew