Hi all,
This is the my data
| DATE | AMOUNT |
| 31/08/2021 | 100 |
| 31/10/2021 | 500 |
| 30/04/2021 | 300 |
Using multi row function need to create YTD column and do amount sum from start of the first month.
Output required
| DATE | AMOUNT | YTD (amount * remaining months in year) |
| 31/08/2021 | 100 | 100*4=400 |
| 31/10/2021 | 500 | 500*2=1000 |
| 30/04/2021 | 300 | 300*8=2400 |
kindly help build the flow using multi row function
