Link to home
Start Free TrialLog in
Avatar of gdspeare
gdspeare

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial