Cross Tab Column Order 1

[geoffreyg]

I would like to have the columns headers of the cross tab to be
January 2001/February 2001/March 2001...December 2001

However, when the cross tab displays, it is in alphabetical order i.e. April 2001/August 2001/December 2001... etc.

How do I get the headers to sort correctly?


Thanks!

 

[MalcolmW]

If it is sorting alphabetically, then the sort is based on a string field.
If you want to sort by date, then your sort needs to be based on a date field.
In your cross tab, for your column choice, choose an appropriate date field, or create a formula that converts the "January 2001" etc to a date field, and then use that formula as your column choice. You can format the date to display as "Month, YYYY" - not showing the day of the month.
If you need some help with any of that, just ask.
Malcolm Wynden
malcolm@wynden.net