G
Guest
Hi
I have a table with a month order field in the format 200511 200510 200509
etc and a seperate table with an appropriate decode Nov 2005 Oct 2005 Sep
2005 etc
I want to do a Crostab based on the last twelve months data and I have set
up a sub query on the decode table and this works as expected
However when this is added to a crosstab and the descriptive narrative is
added as a column heading then the crosstab sorts the data alphabetically ie
Apr 05 Aug 05 Dec 04 Feb 05 etc.
Please could you suggest a solution to retain the sort order for the
crosstab so that the oldest data is in column 1 and the newest in column 12
Please accept my thanks in anticipation
Kind Rgds and Seasons Greetings
Colin
I have a table with a month order field in the format 200511 200510 200509
etc and a seperate table with an appropriate decode Nov 2005 Oct 2005 Sep
2005 etc
I want to do a Crostab based on the last twelve months data and I have set
up a sub query on the decode table and this works as expected
However when this is added to a crosstab and the descriptive narrative is
added as a column heading then the crosstab sorts the data alphabetically ie
Apr 05 Aug 05 Dec 04 Feb 05 etc.
Please could you suggest a solution to retain the sort order for the
crosstab so that the oldest data is in column 1 and the newest in column 12
Please accept my thanks in anticipation
Kind Rgds and Seasons Greetings
Colin