Windowed Sum - Teradata Warehouse Miner

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.

Variable Creation > Input > Variables: SQL Elements pane - Logical > Windowed Sum

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.

Variable Creation > Input > Variables: SQL Elements pane - Logical > Windowed Sum Properties