You can use LOOKUP() or PREVIOUS_VALUE() in a calculated field to use or show values.
Ex: LOOKUP(SUM([Sales]),-1) this would provide you the previous value of column-wise.
To change it down the table, Right click on the created field and go to compute using and select table(down)
Ex: PREVIOUS_VALUE(SUM(SALES)) previous is used only for roe operations. so it would be used row level calculation such as difference or % difference from.
Hope it helps!