Total

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Total

Description

Add a new column with a running (cumulative) total of the selected column.

 

Examples

Total the 'transaction' column:

 

how to add a running total column example

 

Total the 'transaction' column separately for each 'area' value:

 

how to add a cumulative total column example

 

Inputs

One.

 

Options

Set Column to the column you want to total.

Set By to a column if you want a separate running total per value in that column. Leave as <None selected> if you only want a single running total.

 

Notes

Non-numerical values are ignored.

The By column takes account of case and whitespace in values.

The new column is added at the right end. You can change the column order with Reorder Cols and the column name with Rename Cols.

 

See also

Count

Pivot

Stats