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
 

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

Similar Threads

Unable to Group in Pivot Table 1
Expand and collapse 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Grouping Date Data in a Pivot Table 1
how to group time field in pivot table 7
Creating a Calculated Field in a Pivot Table for same field 3
Wanted to show 12 month Date in Pivot table 2
Link Drop Down list with Pivot Table 3

Back
Top