Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Grouping Date Data in a Pivot Table
0 views
Skip to first unread message
Raymond
Jun 27, 2007, 9:15:33 PM6/27/07
to
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.
that data monthly or weekly by grouping the Date field in my pivot table.
Is this possible?
Thanks!
Raymond
gimme_this...@yahoo.com
Jun 27, 2007, 9:23:03 PM6/27/07
to
I've found it helpful to format dates in YYYYMMDD when using dates in
a pivot table.
a pivot table.
Damon Longworth
Jun 27, 2007, 9:59:38 PM6/27/07
to
Right click on the date field - Group. You will have many date grouping
options.
options.
--
Damon Longworth
2007 Excel / Access User Conference
London, England - Currently rescheduled
St. Louis, Missouri - Oct 24-26, 2007
www.ExcelUserConference.com/
"Raymond" <raymo...@gmail.com> wrote in message
news:46830bc8$1...@news.acsalaska.net...
0 new messages