If you're trying to calculate a cumulative sum over an entire table then perhaps you can calculate it in the script instead. If your source table is already sorted correctly then you could try using the peek function.
LOAD
...some fields...,
OrderDate,
Amount,
Rangesum(Amount, CumulativeAmount) as CumulativeAmount
FROM
...source_table...
;
If you source table is not sorted already then you need to load it first into a temporary table and then use a resident load with an ORDER BY clause to sort it.
LOAD
...some fields...,
OrderDate,
Amount,
Rangesum(Amount, CumulativeAmount) as CumulativeAmount
RESIDENT
...unsorted_temp_table...
ORDER BY
OrderDate
;
And if you need to the cumulative amounts restarted for each value of a dimension (or for combinations of values from several dimensions) you need to add a check for changes of those values:
LOAD
...some fields...,
Product,
OrderDate,
Amount,
If(Previous(Product)=Product, Rangesum(Amount, CumulativeAmount),Amount) as CumulativeAmount
RESIDENT
...unsorted_temp_table...
ORDER BY
Product, OrderDate
;
talk is cheap, supply exceeds demand
