Tips & Tricks #28 – Shift Values

 In Tips & Tricks

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


error: Content is protected !!