For South, return month, revenue, ytd (cumulative) and best_so_far (highest monthly revenue up to that month).
6 rows with columns month, revenue, ytd, best_so_far — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | 2025-01-01 | 380000 | 380000 | 380000 |
| 2 | 2025-02-01 | 390000 | 770000 | 390000 |
| 3 | 2025-03-01 | 410000 | 1180000 | 410000 |
Run your code to see the output here.