I would like to enter a formula into a pivot table.

I have the following data.
Item # Qty Date
(thousands of line of data)

I would like to have a pivot table that would calendarize the data
based on the Date, ie

Item # Qty Jan Feb Mar etc
(summarize the Qty by month)


Is this possible and if so how would I go about it.

Thanks

Don