hi all!
i need some help with running total, this is my input data:
| Team | Jan 20 | Feb 20 | Mar 20 | Apr 20 | May 20 | Jun 20 | Jul 20 | Aug 20 | Sep 20 | Oct 20 | Nov 20 | Dec 20 |
| Finance | 20 | 15 | 12 | 14 | 25 | 26 | 32 | 12 | 24 | 23 | 12 | 15 |
| HR | 5 | 12 | 35 | 12 | 11 | 9 | 34 | 12 | 12 | 11 | 22 | 9 |
| Mktg | 14 | 25 | 12 | 35 | 12 | 14 | 9 | 34 | 12 | 24 | 23 | 12 |
I would like to calculate 2 things- spent and to be spent , according to the date
for spent:
for jan, spent = jan for the respective teams
for feb, spent = jan + feb for the respective teams
to calculate to-be spent:
for Jan, to-be spend = feb + Mar + Apr + ... + Dec for the respective teams
for feb, to be spend = Mar + Apr + May + ... + Dec for the respective teams
for Dec, tobe spend = 0 for the respective teams
this is my desired output data: (sorry got lazy to input the numbers for to-be spent)
| Team | Month | Spent | To-be spent |
| Finance | Jan 20 | 20 | 210 |
| Finance | Feb 20 | 35 | 195 |
| Finance | Mar 20 | 47 | 183 |
| Finance | Apr 20 | 61 | 169 |
| Finance | May 20 | 86 | |
| Finance | Jun 20 | 112 | |
| Finance | Jul 20 | 144 | |
| Finance | Aug 20 | 156 | |
| Finance | Sep 20 | 180 | |
| Finance | Oct 20 | 203 | |
| Finance | Nov 20 | 215 | |
| Finance | Dec 20 | 230 | |
| HR | Jan 20 | 5 | |
| HR | Feb 20 | 17 | |
| HR | Mar 20 | 52 | |
| HR | Apr 20 | 64 | |
| HR | May 20 | 75 | |
| HR | Jun 20 | 84 | |
| HR | Jul 20 | 118 | |
| HR | Aug 20 | 130 | |
| HR | Sep 20 | 142 | |
| HR | Oct 20 | 153 | |
| HR | Nov 20 | 175 | |
| HR | Dec 20 | 184 | |
| Mktg | Jan 20 | 14 | |
| Mktg | Feb 20 | 39 | |
| Mktg | Mar 20 | 51 | |
| Mktg | Apr 20 | 86 | |
| Mktg | May 20 | 98 | |
| Mktg | Jun 20 | 112 | |
| Mktg | Jul 20 | 121 | |
| Mktg | Aug 20 | 155 | |
| Mktg | Sep 20 | 167 | |
| Mktg | Oct 20 | 191 | |
| Mktg | Nov 20 | 214 | |
| Mktg | Dec 20 | 226 | |
Thank you in advance!
