Pivot Table: Misordered date Grouping

M

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.
 
J

jeff

Hi,

Can you post a piece of your data/spreadsheet?

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

jeff
 
D

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.
 
Top