Percentage change in time series

[GianluigiBI]

Hi guys,
as you can see from this table I have a list of shops with reveneu for each date.
I have created  "diff" column by setting the modifier in Sum(ammount) by dimension Day.
But now I would like to create a percentage change column, calculated as
(t2-t1) / t1

how can i solve?

Is there a way to set date = date-1 to set lag-1?

[pcv_devo]

Hi @GianluigiBI ,

To move through the records in the table, you can use the Above / Below functions. You can see more information about these functions in the official documentation:

Above function 

Below function