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?

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like2 Follow
  • 2 Likes
  • 1 mth agoLast active
  • 19Views
  • 1 Following