12 month but devided into current and previous year

[Former Member]

hi guys

i have this requirement to disaply amount for current period and previous period for 12 month.

Current period is the period of user entered year and previous period is previous year

So if user enter feb 2007 u2026Then current year is feb, jan ,dec 2006

And previous period is Nov 2006 to March 2006

user is entering the value 0CALMONTH ...and report to need to display 12 month internval betwen years. my problem is how to check the year and interval

please help me without any custom exit? can it be possible thru varibale?

[Former Member]

If you have 0CALQUARTER in your cube, It will be straight forward by offsetting Calender Quareter value by -1, -2 and -3 for last 12 months.

[Former Member]

Hi,

I think i misunderstood your question previously.

You can create offsets on CALMONTH and achieve this easily.

1)In the columns are of query disigner, create selections for 12 months by using CALMONTH and offset each field by -1 or -2,-3,-4 ..... -12.

2) Create a Text Variable to show the month Value in column header

3) Create a structure in columns area and place it below all the CALMONTH selections

4) Include all your Key Figures inside the structure.

[Former Member]

hi

i can easily display all 12 month period but my requirement is to calcualte within 12 month how many are curent and how many are previous years

say user enterd march 2007 .....

i need to calculate total amount for march 2007 to jan 2007 ...and dec2006 to april2006 separatly which will give me 12 month but 2 diferent years value ...

i just need 2 column with 2 periods data as curent and previous