Display month value start from april to march (financial year) in order

[saumil287]

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

[HalfBloodPrince]

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.

[saumil287]

Hi I tried the same but still displaying in incorrect order.
I want from april to march ie financial year
thanks in advance

[HalfBloodPrince]

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

[saumil287]

Hi
mY month col is already having the case stat to replace nos with month names
Thanks

[HalfBloodPrince]

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.