Current Year and Previou year Data comparision - Urgent

[Former Member]

Hi Experts,

In our report we need to compare the sales value for current year and prevous year.

The Fiscal year is the input selection field.

Output report displayed as below

Product|Current year sales|Previous year sales|

404 |120.00 |20.00

400 |122.00 |22.00

-

---

Total |242.00 |42.00

Could any body help how do i use the fiscal year/period or fiscal year for the current sales and previous sales values.

Thanks in advance.

Mahantesh

[Former Member · Accepted solution]

You have to restricit current year column with the variable Fiscal year and previous year colum with same variable with offset -1.

For year period use a range with from valie '001.1990' and to value a variable for current and the same variable with offset -12 for previous.

Hope it helps.

Regards

[Former Member · Accepted solution]

Hi,

Thanks for the suggestions...i solved it by using the standard variable of fiscal year but i am not able to use an offset for custom variable...is it possible touse offset in z variables.....

rewarded points for the feedback..

thanks,

mahantesh

[Former Member · Accepted solution]

Usually no problem and difference among std and custom variables...do you see the function not available or what ?

Bye,

Roberto

[Former Member · Accepted solution]

Hi Mahantesh..

I had a similar problem..I believe you will be able to assign offsets if you have the Fiscal year selections in a structure..

Ashish..

[Former Member · Accepted solution]

Hi Ashish, I am able to assign the offset for the standard variables but not custom variables. i don't know why it is showing in display mode(offsets)...

regs,

mahantesh

[Former Member]

Hi dear,

simply use the same variable of the selection creen to restrict the same KF 'sales', with any other operation for current year and with an offset of '-1' in the previous year one (right click on the variable, define offset...)!

Hope it helps!

Bye,

Roberto