Grouping Date Data in a Pivot Table

[Raymond]

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

 

[gimme_this_gimme_that]

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

 

[Damon Longworth]

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/


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