Pivot table formulas

D

don

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
 
T

thechilipino

hello don:

when you set up the pivot table, have 'date' in the column area.
right-click on the 'date' field heading -> Group and Show Detail -> Group ->
you then have the option to select 'Months'. this will group your dates into
Months.

please comment if that solution worked.

cheers. chili.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top