Pivot

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Pivot

Description

Creates a pivot table to summarise values for 1 or 2 columns.

 

Inputs

1

 

Options

Use Pivot column to select the columns values you want to use as columns in your pivot table.

Use Pivot row to select the columns values you want to use as rows in your pivot table.

Use Pivot sum to select which column you wish to sum.

 

Notes

Pivot tables are very useful for analysing data.

Any non-numerical values in the Pivot sum column are ignored.

 

See also

Stats