How to sort Across column heading? I have month on Across column and it is out of order.

 

  JAN FEB MAR APR.... 
1  12  12  1   9

This message has been edited. Last edited by: Riya,

What is the format of the month? If it is alpha, you can use ACROSS COLUMNS syntax. Or sort across the month number and NOPRINT it as well as the alpha month.

I hope this is what you are looking for. If not please supply the format of the field containing the month you are sorting on.

You can use 'HIGHEST' OR 'LOWEST' before the column to sort the column.

If you are looking for Customized sorting then Go ahead with Ginny's Solution

The other option with across is the key word COLUMNS.

e.g.
ACROSS FIELD COLUMNS Val1 AND Val2 AND Val3 ....

Thank you all for your reply.

This is a alpha field. I created a case statement with numbers and sorted by that number. It worked.

Thanks again for your suggestion.