I am trying to plot a graph in OBIEE 11g answers which shows Calendar Month in X-axis and percentage of marks in Y-axis,
in such a way that Calendar Month in X-axis should be in the order Jan Feb Mar Apr .....(where as now it is Apr Aug Feb ... which is sorted in ascending order) Calender month is a calculated column in the report which has the following calculation
case when cal_month=1 then 'Jan'
case when cal_month=2 then 'Feb'
case when cal_month=12 then 'Dec'
How do i arrange the calendar month in a proper order of Jan Feb Mar .....
Hi Srini... Thanks for ur quick reply, but i have a doubt on it.
I have a col with name cal month which is used in the calculation of the Calender month col. cal month has the data 1,2,3....12.
Where as the column Calender month has the calculation i already mentioned. Now if i use the cal month column in my report the graph looks good, but i don't want 1,2..12 in the graph instead i want jan, feb .. dec. The solution which u told will work only if the col Calender month is also in RPD right? Plz correct me i have understood u wrongly.
Month column is used for reporting which is calculated column of Col_month in answers. This Month field is not there in the rpd. So how do i achieve sort column in rpd level.
or do we have to do something in answers?