Sorting Crosstab Columns

I have a crosstab that has dates across the collumns.  I am trying to figure out a way to sort the columns by date and am having some difficulty. They are sorting alphabetically.  

I have tried the below 3 in addition to some other versions, but still the sorting is from low to high.

MonthName(Month({Rpt453;1.POST_DATE}),TRUE) & ' ' & TOTEXT(Year({Rpt453;1.POST_DATE}),0,'')
//TOTEXT(Month({Rpt453;1.POST_DATE}),0,'')&'/' & TOTEXT(Year({Rpt453;1.POST_DATE}),0,'')
//TOTEXT(Year({Rpt453;1.POST_DATE}),0,'') & TOTEXT(Month({Rpt453;1.POST_DATE}),0,'')

Thanks for the ideas.
gdspeareAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Is the cross tab grouping on the date field?
If so simply specify group by month

You can format the field in the cross tab to show it as desired.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.