Hello,
I am attempting to calculate the YTD, MTD, CYTD and revenue to date for a very large data set which spans the past three years. I have included a small sample below and welcome suggestions on the best way to achieve this. Kind regards,
Esther
<tbody>
</tbody>
I am attempting to calculate the YTD, MTD, CYTD and revenue to date for a very large data set which spans the past three years. I have included a small sample below and welcome suggestions on the best way to achieve this. Kind regards,
Esther
Year | Month | Banker | Segment | Product Type | Relationship name | Product name | Balances |
2016 | Nov | 67771 | |||||
2016 | Dec | 38881 | |||||
2016 | Dec | 38401 | |||||
2017 | Jan | 23011 | |||||
2017 | Jan | 17625 | |||||
2017 | feb | 45282 | |||||
2017 | feb | 34627 |
<tbody>
</tbody>