UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

 
   Reply to this topicStart new topic
> Pivot Table Group By Month Through Weekly Date, Office 2002    
 
   
lisa2004
post Mar 29 2010, 12:20 PM
Post#1



Posts: 483
Joined: 30-December 04



I have created a pivot table based on weekly date,the earliest date is 3/2/2009. When I group date by month, why I got from Jan?
Thanks,
Lisa
Go to the top of the page
 
norie
post Mar 29 2010, 12:40 PM
Post#2


UtterAccess VIP
Posts: 4,448
Joined: 29-April 06



Lisa
That do you mean?
Are you dealing with real dates? What do you mean by 'weekly date'? Is that just a typo and you mean weekly data?
Go to the top of the page
 
lisa2004
post Mar 29 2010, 12:45 PM
Post#3



Posts: 483
Joined: 30-December 04



I found the reason. When grouping by month, the date no longer show year, only the month name. My date is from 3/2/2009 to 2/22/2010. It listed Jan/2010, and Feb/2010 first. No longer sorted by year. I have to group by both year and month. How can I show both year and month together?
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    2nd August 2015 - 07:17 AM