Option 1: Sort on a custom columnInstead of sorting the date column directly, create a new calculated sort column, and use it as on the vertical axis before the date column.
For example, say you have a [Date] column, and you use it on the cross table vertical axis, this results in an expression like:
<[Date]>
Edit the axis expression by adding in a rank expression, like:
DenseRank([Date],"desc") as [Index]
resulting in:
<DenseRank([Date],"desc") as [Index] NEST [Date]>
See the attached sample dxp file page 1 for an example.
Option 2: Use IronPython to change custom sort order for the date column.This can also be done with an Iron Python script based on this example in the TIBCO Community Wiki:
Note: When new data is added in, you need to reconfigure the custom sort order so this might not be a good solution for a large data sets or a large number of data tables or any data that will change regularly.
See the attached sample dxp file page 2 for an example.