I am trying to create a calculated field which would have a similar output as the runningSum function, however, the new function/calculated field will stop summing values after a defined period (Week, month, etc…), return the summed value (i.e 26th to 29th of march) and start again for the next period (i.e. Apr 5th to April 29th) as shown in the example below.
The required field will be “datetime” and “value”. the column “balance” should present the expected output
Is there a way to do it?