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.

 

Example

total-example-1

 

Totalling the transaction column:

 

total-example-2

 

Gives a running total of transactions:

 

total-example-3

 

Totalling the transaction column by area:

 

total-example-4

 

Gives a separate running total for each area:

 

total-example-5

 

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