This content has been marked as final. Show 7 replies
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.
I've already mentioned OOB column to use, I'm not sure about your data. If you dont have it then might go for workaround to get number 1 to 12.
BTW:Existing column 'Col month' as referred is not helping you?
For ex: work around might be something like
cast(substring("Year",3,2) as int)
Mark if helps
Edited by: Srini VEERAVALLI on Feb 5, 2013 12:43 AM
you can create same in rpd so that you can sort it._
Or else can go with work around using year column as above_
Edited by: Srini VEERAVALLI on Feb 5, 2013 12:59 AM
Edited by: Srini VEERAVALLI on Feb 5, 2013 1:01 AM
Edited by: Srini VEERAVALLI on Feb 5, 2013 3:19 PM