Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a SQL table with three integer columns, Year, month and total. I can show that in a 'Draaitabel' with month horizontal and year vertical. Horizontal needs to be sorted on month (1,2,3). Now I want not to show the month numbers, but the month names. I can do that with the Longmonthnames, but then the sorting goes all wrong. Houw can I sort the monthnames on their 'integer' values?
Check Uploading a Sample
Thanks,
Here is a qvw test file.
What i'm looking for is:
-A column for each month of the year (evenif there are no input records for thes month)
-The columns sorted in the correct sequence (jan-feb-mar etc.)
Thanks,
Paul Berendts
Probably you have forgotten to attach the file. However, now that you say:
Paul Berendts wrote:
..-A column for each month of the year (evenif there are no input records for thes month)
I guess you have to use a master calendar to generate all the missing dates/months. Have a look here:
Master Calendar Generation Script
Thanks,
Here is a qvw test file.
What i'm looking for is:
-A column for each month of the year (evenif there are no input records for thes month)
-The columns sorted in the correct sequence (jan-feb-mar etc.)
Thanks,
Paul Berendts
Try calculated dimension like:
=Month(MakeDate(1,Maand))
Thank you, exactly what I was looking for.