Sort Order in Cross Tab

[sashalarsen]

Currently the cross tab tool automatically sorts alphabetically by the "New Column Headers" field. Often times I have to output data with dates across the columns and therefore have to do a cross tab to achieve this. The problem is when I have the dates formatted with month names, the crosstab automatically sorts it in alphabetical order instead of date order (i.e. Apr, Aug, Dec, etc vs Jan, Feb, Mar). To get around this issue, I have to use a dynamic rename tool. It would be great if there was a way to choose the order of the crosstab (i.e. in the order of the data, crosstab, another field, etc.).

[CristonS]

Thank you for your idea! Unfortunately, due to technical restrictions with the behind-the-scenes Engine processes, we will not be implementing this idea. We appreciate users for submitting their ideas and contributing the the Community as a whole.