Tips & Tricks #28 – Shift Values
New year and new commands.
This is new in the menus, I have used something called “Lag” Before.
Here is the file with sales result per month, I will shift values 2 steps forward in the data file, to be able to calculate the difference between one month and 2 months earlier.
Here you find the command:
Then do the following and finish with “OK”:
Here is the result variable “Sales_2”:
So now you can just calculate the difference by a simple “Compute” command:
Sales – Sales_2 to see if the sales has decreased or increased since 2 months back.
Greetings Gunilla Rudander