Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm unable to sort according to fiscal month.
PFB the screenshot
I'm getting the above issue only for few selections.
I'm using the below expressions:
1) Mod(MC_Month+8,12)
2) wildmatch(MC_Month,vMonth1, vMonth2, vMonth3, vMonth4, vMonth5, vMonth6, vMonth7, vMonth8, vMonth9, vMonth10, vMonth11, vMonth12)
vMonth1 = month(min(ATD_Period)) --> Apr
vMonth2 = month(min(ATD_Period,2)) --> May
vMonth3 = month(min(ATD_Period,3)) --> Jun
and so on.,
Both the expressions aren't working:(
Could you please do the needful on the above issue.
Thanks in advance.
Regards,
Jesh
try to load this
LOAD * INLINE [
Month, MonthName, Quarter
1, Apr, Q1
2, May, Q1
3, Jun, Q1
4, Jul, Q2
5, Aug, Q2
6, Sep, Q2
7, Oct, Q3
8, Nov, Q3
9, Dec, Q3
10, Jan, Q4
11, Feb, Q4
12, Mar, Q4
];
For months, do sort on Load Order
Hi Chanty,
This doesn't seems to work.
Thanks & Regards,
Jesh