How do you associate a value list with a calculated field for sorting in a script?
In a table view I can use the pull down menu on a field/column and choose sort by value list.
This works just fine.
When I try to do this in a script with the sort by field statement it allows to sort by associated value list.
I am doing this so my charts have an appropriate order, think days of the week, or months of the year type ordering.
For the same calculated field I sorted by in the table, how do I associate a value list for the sort in a script.
Any thoughts or ideas are most welcome,