Good day,
I would like to make a MTD (monthly to date) calculation of data by cumulating monthly data from 2018 in QS script.
Here is an example of the calculation in Excel:
![Tatynout_0-1619622244389.png Tatynout_0-1619622244389.png](https://community.qlik.com/t5/image/serverpage/image-id/53899i867C94169F0777AF/image-size/medium?v=v2&px=400)
Here is how the data should be represented in QS for every year:
![Tatynout_1-1619622719110.png Tatynout_1-1619622719110.png](https://community.qlik.com/t5/image/serverpage/image-id/53900iE5BB7AE1F3D63E31/image-dimensions/737x325?v=v2)
I please need help to calculate my MTD field into QlikSense script.
I have attached the excel file to this post.
Thanks for your help.
Tatiana