X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | 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

UtterAccess Veteran
Posts: 483



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



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

UtterAccess Veteran
Posts: 483



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
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 20th December 2014 - 11:43 PM