How to derive Fiscal Quarter?

[narayanamsn]

Hi,

I have Months and want to derive Fiscal Quarters.

How to derive the Quarter based on Month while my year starts with Nov?

Month	Qtr
Nov	1
Dec	1
Jan	1
Feb	2
Mar	2
Apr	2
May	3
Jun	3
Jul	3
Aug	4
Sep	4
Oct	4

Regards,

Satya

[PrashantSangle]

Hi,

might be this thread help you

Creating Qtr View in Cross table

Regards,

[tresB]

Try like:

Ceil(If(Month>10, Month-10,  Month+2)/3) as QuarterNum;

[tresB]

If your month is not a dual field, you might try like:

Load

       Ceil(If(Month>10, Month-10,  Month+2)/3) as QuarterNum;

Load

       Month(Date#(Month,'MMM')) as Month  Inline [

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec]