Cumulative, Group, Moving and Remaining Sum are supported within the Windowed Sum function. This function derives a new column for a value expression giving the cumulative, group, moving or remaining sum of the value expression when sorted by a sort expression list. When one or more Partition Columns are specified, the sums are accumulated only over the rows in each partition (the start of a partition resets the accumulated sum to 0). Any of the Rows options may be used to determine the type of sum to compute. When dragging a Windowed Sum function into a variable, the following tree element is created.
Sort expressions can be built up in the Sort Expressions folder, and Partition Columns can be built up in that folder. The options to perform a Cumulative, Group, Moving or Remaining Sum and their associated options are enabled through the Properties panel. Double-click on Windowed Sum, or highlight it and click Properties.
-
Aggregation Style — CumulativeSecond Row Style
- None, or
- Current Row, or
- Value Preceding, or
- Value Following.
(If Value Preceding/Following)
Second Value — 0-n
- Aggregation Style — Group
-
Aggregation Style — MovingFirst Row Style
- Current Row, or
- Value Preceding, or
- Value Following.
(If Value Preceding/Following)
-
First Value — 0-n
Second Row Style
- None, or
- Current Row, or
- Value Preceding, or
- Value Following.
(If Value Preceding/Following)
Second Value — 0-n
-
Aggregation Style — RemainingFirst Row Style
- Current Row, or
- Value Preceding, or
- Value Following.
(If Value Preceding/Following)
- First Value — 0-n