Grouping Date Data in a Pivot Table

  • Thread starter Thread starter Raymond
  • Start date Start date
R

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
 
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/


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