Year Over Year

[Former Member]

Hi,

We need to show sales for artcile for this month (MTD) and same for the last year period (YOY).

we tried using fiscal year option, 0calmon -12 offset. but no result.

any help??

thanks in advance.

regards: gaurave

[Former Member]

Hi Gaurave,

Plz check it once again,whether it is calmonth or fiscal period.

Thanks,

Vijay

[Former Member]

I've checked both options

Calmonth and also fiscal year.

[Former Member]

I've doubt if u use calyear u need to go for calmonth.

if u use fiscal year then u need to consider fiscal year period.

[Former Member]

any more help?

its not working with fiscal year/period. nor with year/month.

[Former Member]

Let the User Entry Mandatory Variable be ZFISCPER & Posting Period be ZPOSTPER

Place the Keyfigure in Rows.

Create 2 selections in Columns.

Selection1 - Fiscal Period - Restrict it to ZFISCPER - Posting Period - ZPOSTPER

Selection2 - Fiscal Period - Restrict it to ZFISCPER - Offset to <b>-1</b> - Posting Period - ZPOSTPER

Were you trying something similar ??

Also are you looking data for the same selections ..

Message was edited by:

Jr Roberto

[Former Member]

Offsetting Fiscal Period to -12 may not work as it may have 16 Posting Periods.

[Former Member]

Check if it is because you don't have any data for that month in the infoprovider? Giving an offset of -12 to the calmonth variable is a very standard way of doing this.

Thanks.

Sumit

[Former Member]

There is data for both months (this year and last year).