Problem in sorting Fiscal month

[#1]

Hi all

In a line chart i want to sort month from april to march

X axis - month

Y axis(Sales)=Sum({<SALES_DATE=,YEAR=,MONTH=,QUARTER=,FiscalYear=,WEEK=>}NET_AMOUNT)

I used Sort expression like this for sorting in sort tab--> expression

=Match(MONTH,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

I am not using master calendar but i am using calender object for date(SALES_DATE)

My problem is when there is no date selected in calender object its working fine(Fig1).But its not working when some date is selected(Fig 2)

I dont know whats happening.

Can anyone help me how can i solve this

[#2]

go to chart properties and under sort tab click on dimension month and uncheck all the sort order and check Load order option,this will sort your month correctly    

[#3]

Hi Bhawna

Its not working.

[#4]

Anyone pls Help me to solve this

[#5]

Not only calendar date even when i select month or quarter also its not working

[israrkhan]

i think you have to use pick() function with match()..

like below

Pick(Match(MONTH,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'), 1,2,3,4,5,6,7,8,9,10,11,12)

or second option is , generate a table in script like below..

load * Inline [

MONTH, Number

Apr,1

May,2

Jun,3

Jul,4

Aug,5

Sep,6

Oct,7

Nov,8

Dec,9

Jan,10

Feb,11

Mar,12

];

it will link automatically to your month field, and than in the sort table, sort it as "Numeric value"

hope it helps...

[aveeeeeee7en]

Use this Expression:

=Dual(MONTH,Match(MONTH,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'))

Regards

Aviral Nag

[#8 · Accepted solution]

Thank you all for your help

I dont know what the problem is but i fixed the problem by using alternate state so it remains same whatever i select.

[Charlie007]

Please share the solution of this issue  as I am facing same problem when the data of future period does not exist. I am waiting for your reply and hope to receive it soon.