# Calculating week on week growth change

Following on from my previous question, I have a table as below:

```  Weekly Date   User ID   Profit   Cumulative Profit
------------- --------- -------- -------------------
01/01/2020        123       23                  23
08/01/2020        123       35                  58
15/01/2020        123       12                  70
01/01/2020        918       53                  53
08/01/2020        918      279                 332
15/01/2020        918      726                1058  ```

where cumulative profit is generated with cumulative_sum( profit, <date_column>).

I would like to add a column that tracks the growth in cumulative profit by each week, to get something as below:

```  Weekly Date      User ID      Profit      Cumulative Profit   % growth
---------------- ------------ ----------- ------------------- -----------
01/01/2020            123          23                  23           0
08/01/2020            123          35                  58     152.174
15/01/2020            123          12                  70     20.6897
01/01/2020            918          53                  53           0
08/01/2020            918         279                 332     526.415
15/01/2020            918         726               1058     218.675   ```

does anyone have a formula for calculating this?

• Oldest first