Unable to sort according to fiscal month

[Jesh19]

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

[Chanty4u]

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

[Jesh19]

Hi Chanty,

This doesn't seems to work.

Thanks & Regards,

Jesh