SORTING-Load Order

[Anonymous]

Hi,

I need the load order of the months to be sorted in the script. For year 2017, the months seem to be sorted but for 2018 it starts from Month 6(using fiscal calendar starting from OCT-Month1).

I need to sort it in the script itself and not as a chart property. Thanks!

X-Axis: 'FY' & right(num#(FiscalYear),2) & ' ' & 'M' & num#(FiscalMonth) as testdate

[CarlosAMonroy]

Hi Chandni,

It's better and easy to sort if you create the 'MonthYear' field in the backend (script.)

I guess you have Fiscal Date, so you can create the new field based on that.

Would be great if you share a sample file.

Regards,

Carlos M

[sunny_talwar]

What is the script that you are using?

[jolivares]

I feel that you need to redo your calendar table (I hope that you are using one)

Load Dual(MyMonth,MyFiscalMonth) as MyFiscalMonth2

  MonthName(MakeDate(FYear,MyFiscalMonth) as MonYear;

Load Normarl_Date,

Month(Normal_Date) as MyMonth

  Mod(Num(Month(Normal_Date))-10,12)+1 as MyFiscalMonth  //10 is the first fiscal month for you

  Year(Normal_Date) + If(Month(Normal_Date)>=10,1,0) as FYear

...