By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| weekno | pctweek | theamount | cumulative | pct |
|---|---|---|---|---|
| 1 | 1 | 5480.00 | 5480.00 | 100.000000 |
| 2 | 1 | 5480.00 | 5630.00 | 97.335701 |
| 2 | 2 | 150.00 | 5630.00 | 2.664298 |
| 3 | 1 | 5480.00 | 5830.00 | 93.996569 |
| 3 | 2 | 150.00 | 5830.00 | 2.572898 |
| 3 | 3 | 200.00 | 5830.00 | 3.430531 |
| 4 | 1 | 5480.00 | 7830.00 | 69.987228 |
| 4 | 2 | 150.00 | 7830.00 | 1.915708 |
| 4 | 3 | 200.00 | 7830.00 | 2.554278 |
| 4 | 4 | 2000.00 | 7830.00 | 25.542784 |