I've created a pivot table that counts daily events and I would like to show
that data monthly or weekly by grouping the Date field in my pivot table.

Is this possible?

Thanks!

Raymond

I've found it helpful to format dates in YYYYMMDD when using dates in
a pivot table.

Right click on the date field - Group. You will have many date grouping
options.

--

Damon Longworth

2007 Excel / Access User Conference
London, England - Currently rescheduled
St. Louis, Missouri - Oct 24-26, 2007
www.ExcelUserConference.com/


"Raymond" wrote in message
...
I've created a pivot table that counts daily events and I would like to show
that data monthly or weekly by grouping the Date field in my pivot table.

Is this possible?

Thanks!

Raymond