Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good evening,
i've an excel file like this:
DATE,QUANTITY,MONTH, YEAR,
01/01/2021, 10, 01,2021,
05/02/2021,50,02,2021,
06/03/2021,80,03,2021;
I would like to create in the script area a cumulative value-->
YEAR, MONTH, QUANTITY
2021, 01, 10,
2021,02,60,
2021,03,140
P.S. i need to do it in the script area because i have other tables with different data field
if i have a value from the previous year i want it in the sum....