Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
What is the script that you are using?
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
...