Cross Tab Sorting Columns

[dgillz]

I have little experience with Cross Tab reports.

I inherited one with month names as columns. But the sort is April, August, December, etc. - Alphabetic sort. How do I get this to sort as January, February, March, etc.?

Macola and Sage 50/Sage 100 Consultant

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[hilfy]

Try this:

1. Create a month group using something like this following formula:

ToText(Month({MyTable.DateField}), "00") + "-" + ToText({MyTable.DateField}, "MMMM")

2. Use this formula as the column. It will sort correctly by month number instead of by month name.

3. If you want to show just the month name without month number in the column header, right-click on the header object and select Column Options >> Group Options and go to the Options tab. Check "Customize Group Name Field" and use this formula for the group name:

ToText({MyTable.DateField}, "MMMM")

-Dell

Associate Director, Data & Analytics
Protiviti

http://www.protiviti.com