to order months according fiscal year

[maternmi]

Hello,

I want to reorder the months of a calendar year according our fiscal year, which starts with April and ends with March.

How can I do it in a list box?

Thanks!

Best regards,

Michael

[Gysbert_Wassenaar]

See this blog post: Fiscal Year

[daveamz]

Hello Michael,

You can assign the order with a inline table like:

LOAD * Inline [

FiscalMonth, Order

201304, 1

201305, 2

.....

];

and then sort it by Expresion: Order

Best regards,

David

[tresesco · Accepted solution]

Or, if you want adhoc front-end solution, try sort order expression like:

=Match(MonthField, 'Apr', 'May', 'Jun', 'July', ...)

Or,

If(Num(MonthField)<4, Num(MonthField)+12, Num(MonthField))