Is there a way to use TIMESUM or MOVINGSUM to sum all values in a time series up to the current date? Essentially creating an 'inception to date' calculation.
For example, if I have a monthly time series with the values 1,2,3,4,5 then I want my inception to date calculation to return 1,3,6,10,15.
I can achieve this by using MOVINGSUM(line item, -1000, 0) but I'm wondering if there is a better way to do this?