MSUM

Calculate a moving sum for the last n rows of the data, Inclusive of the current row. The Moving Sum is used mainly to identify trend direction.

Syntax: MSUM(expr, integer)

Syntax description

expr is any expression that evaluates to a numerical value.

integer is any positive integer. Represents the sum of the last n rows of data.

Steps: Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on Running Aggregate folder and select MSUM

Example: MSUM("Sales"."Rp Revenue",2)