How to fetch the previous value in a column or row?

Question

How to fetch the previous value in a column or row?

Answer 1

Hello Vaibhav,

You can use LOOKUP() or PREVIOUS_VALUE() in a calculated field to use or show values.

Using Lookup()

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)

Using PREVIOUS_VALUE()

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!