Cumulative value for each date.

[louise119]

I want to output the result of the formula below as a cumulative value for each date.
What should I do?
How can I write a formula to calculate the cumulative value for each date?

count(if(Region_ID=3, Region_ID))

[Somasundaram]

Try this,

Load
Date,
if(Date<>previous(Date),Value,Rangesum(peek('Cum_Value'),Value)) as Cum_Value

from table