Hi all,
I am having a month data item which is month extract from postingdate column.
In bar chart when I take the month col in categories x-axis, the month values are displaying in incorrect order.
In series , there is ytd and ytd_ly query item.
thanks in advance
Hi try this
First add posting date column in Ur query than
Go to advance sort option here add Posting date column sort ascending then add Month column under posting date sorted in ascending order.
Hi I tried the same but still displaying in incorrect order.
I want from april to march ie financial year
thanks in advance
Try too create query calculation Sort as
if( month ='April' ) then
(1)
else
if( month ='May' ) then
(2)
and sort month according to sort column
Hi
mY month col is already having the case stat to replace nos with month names
Thanks
If your month column is a calculated field then original month data must be in number like 1,2 4. If yes then in advance sort
fist sort numeric month ascending than add calculated month below it sorted ascending.