Cumulative column

Calculate the cumulative sum of a column containing values.

Optionally, you can calculate the cumulative sum according to a certain sort order.

Dialog box options:

Column:	Select a value column of which you want to calculate the cumulative sum.
Sort by Column:	Optionally, select a column on which you wish to sort while calculating the cumulative sum.
Output column:	Type a new column name. A dependent column will be created.

The Column Properties dialog box will appear.

Tips:

If you choose to sort on a column during a cumulative sum, it is a good idea to sort the table on that column as well: choose Sort from the Columns menu.
To calculate sums per group, choose the Aggregate command on the Columns menu.

Command line syntax:

You can also perform the cumulative sum calculation on the command line of the table window. Type one of the following expressions:

outcol = ColumnCumulative(col)

outcol = ColumnCumulative(col, sortcol)

outcol = CUM(col)

outcol = CUM(col, sortcol)

where:

outcol	is the output column name;
col	is the name of the column which contains the values of which you wish to calculate the cumulative sum;
sortcol	is the name of the column on which you wish to sort before calculating the cumulative sum.

Table window