Print Page - How to sort/order x-axis in chart

Title: How to sort/order x-axis in chart
Post by: khoinh on 20 Jul 2010 06:05:34 AM

Hi,

I have the chart with x-axis is name of month (Jan, Feb, Mar,...). At now, x-axis of my chart is sorted by alphabetically. I want to apply order from Jan to Dec into my chart. Is there any way to accomplish this? ???

Thanks
Khoi

Title: Re: How to sort/order x-axis in chart
Post by: imts on 20 Jul 2010 06:17:03 AM

u must be having some column like MONTH_ID in ur DB ; get it in ur query and sort on it.

Else create a data item like
case
when ( 'jan') then (1)
when ('feb') then (2)
...end

like this.

And do an advance sort on this data item.

-TS

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: khoinh on 20 Jul 2010 06:05:34 AM