For each month of 2024 with orders: month, revenue, cumulative and pct_of_year (cumulative ÷ year total, 2 decimals), in order.
12 rows with columns month, revenue, cumulative, pct_of_year — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | 2024-01-01 00:00:00 | 9941 | 9941 | 10.73 |
| 2 | 2024-02-01 00:00:00 | 7392 | 17333 | 18.7 |
| 3 | 2024-03-01 00:00:00 | 11689 | 29022 | 31.32 |
Run your code to see the output here.