Hi all -
I have a cross tab with Months as column headers, e.g. Jan, Feb etc...
However, the Cross Tab function puts the months in alphabetical order - see attached image. i.e. Apr, Aug, Feb etc...
I need the data to be shown in 'normal' Jan, Feb, Mar, Apr order.
Any ideas?
Thanks
RDF
hey @RDF25087 what I do in this situation is create a formula and create a new column called month sort and then just assign a number to each month ie:
If [month] = 'January' then 1 and so on for the other months.
Then before you cross tab sort on the month sort column you just made