I have a dataset that has year and month (formatted "Mmm") as separate columns. When I pivot that dataset, for some reason the months continually sort as:
Oct, Nov, Dec, Jan, Feb... Sep.
I'd like the year to start with January. Not sure why it won't. Have looked at everything obvious, and have used pivot tables many times. Never saw this before. Sample attached.
Any ideas?
Bookmarks