Cross Tab - Dates in column are alphabetical - need them in correct order

RDF25087

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

Cross Tab Image.png

Deano478

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