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.P OST_DATE}) ,0,'')&'/' & TOTEXT(Year({Rpt453;1.POST _DATE}),0, '')
//TOTEXT(Year({Rpt453;1.PO ST_DATE}), 0,'') & TOTEXT(Month({Rpt453;1.POS T_DATE}),0 ,'')
Thanks for the ideas.
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.
//TOTEXT(Month({Rpt453;1.P
//TOTEXT(Year({Rpt453;1.PO
Thanks for the ideas.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.