MovingSum (Moving Sum) function operates over a moving window of values. For each Window, the MovingSum returns the sum of values found in the window. No “Weighted” or “Exponential” can be calculated for this function.
The MovingSum function takes the following arguments:
MovingSum (column, window, break_col)
column (required)—Specify the column that contains the numeric fact on which the Moving Function column value is calculated. If you are applying the function from the Pivot section, you can only use a column that has already been added to the Facts pane of the data layout.
window (optional)—Specify a moving “window” of values from the Column on which the Moving Function gets calculated The window value must be a positive integer of value equal to or less than the total number of rows in the Column (within any Break Column value). If the window value is an interger of greater value than the number of values in the Column, then the window value defaults to the number of rows in the Column (within any Break Column value). If no window value is specified, then the window value defaults to 3.
break column (optional) —Specify the name of the column on which to perform the Moving Function calculation. The break column refers to the rows of similar valued data cell within the Pivot or Results section.
The following results would occur if you used the Moving Sum function with a Window value of 3.