Pivot

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Pivot

Description

Creates a pivot table to summarise values for one or two columns.

 

Inputs

One.

 

Options

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

Use Pivot row to select the column 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

Count

Stats

Summary