formulae in Pivot Table
 

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

formulae in Pivot Table
 

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