Pivot Table: Misordered date Grouping

[Mark G.]

I'm having a problem where the grouping is coming out
wrong. I have dates ranging from October 2003 to June
2004. When I group by month, it gives me a January -
November groupings vs. a October - June groupings. In
other words, the October and November months should be in
the first two columns given their dates come first.

Thanks,

Mark G.

 

[jeff]

Hi,

Can you post a piece of your data/spreadsheet?

I can't get it to do what you describe.

jeff

 

[Debra Dalgleish]

If you group by month name, January will come first.
If you group by year and month, the 2003 months would be listed first.

 

[Mark G.]

That did it. Thanks.

-----Original Message-----
If you group by month name, January will come first.
If you group by year and month, the 2003 months would be listed first.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.