This action shifts values in specified column up or down. When a column is shifted down, empty cells are inserted at the top of the column. When shifted up, empty cells are inserted at the bottom.
This action can be used in cases when a comparison with a previous/future period is required.
Source data: sales by year.
Objective: Calculate the delta with previous year. For this, we're appending a new column which is column [Sales] shifted down by 1 row.
|Year||Sales||Prev. year sales|