formulae in Pivot Table

A

andreww

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
 
T

Tom Ogilvy

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.
 
Top