About the Pivot view

The Pivot view lets you create multi-way tabulations and calculations. A pivot table is useful for creating tabulations over a large data set, and can be copied as a separate data table for further analysis. The Pivot view consists of one or more pivots and one or more aggregate functions.

A pivot refers to one or more columns used to define rows in the pivot table; each row then corresponds to a particular combination of values in the pivot. For example, if the data table is a list of people, and a pivot includes sex and age, the pivot table will have rows for "male" and "18", "female" and "18", "male" and "19", "female" and "19", and so on. For category columns, each category value will be used in the pivot; for non-category numeric columns, ranges of values corresponding to the column’s quantiles will be used.

One or more aggregate functions can then be applied to the pivot. An aggregate function performs a calculation over all records with a particular set of values defined by the pivot. By default, a count aggregate function appears in the Pivot view which tells you the number of records that correspond to each row in the pivot table. Other aggregate functions can produce summary statistics of columns of interest.

The aggregate functions available for category columns are:

• Category counts
• Category proportions
• Mode
• Minimum and maximum
• Median, lower quartile, and upper quartile
• 1st percentile, 2nd, 5th, 10th, 90th, 95th, 98th, and 99th percentile
• Count all records
• Count records with non-missing values
• Count distinct values

The aggregate functions available for non-category text columns are:

• Count all records
• Count records with non-missing values
• Count distinct values

The aggregate functions available for numeric columns are:

• Mean (average)
• Sum
• Mode
• Minimum and maximum
• Variance and standard deviation
• Standard error of the mean and confidence interval of the mean
• Median, lower quartile, and upper quartile
• 1st percentile, 2nd, 5th, 10th, 90th, 95th, 98th, and 99th percentile
• Count all records
• Count records with non-missing values
• Count positive values, negative values, and zero values

The aggregate functions available for date/time columns are:

• Mode
• Minimum and maximum
• Median, lower quartile, and upper quartile
• 1st percentile, 2nd, 5th, 10th, 90th, 95th, 98th, and 99th percentile
• Count all records
• Count records with non-missing values

A list of aggregations appears on the left of the Pivot view. The pivot columns can be configured at the bottom. In the main pivot table, columns used in the pivot will appear to the left of columns displaying the results of aggregations. Ditto marks (〃) indicate repeated pivot values. Note that you can set up multiple independent pivots and then apply the defined aggregate functions to any pivot in the pivot drawer.

See also:

• Creating an aggregation in the pivot table
• Changing the aggregate function used in an aggregation
• Deleting an aggregation from the pivot table
• Hiding an aggregation in the pivot table
• Creating a new pivot in the Pivot view
• Deleting a pivot from the Pivot view
• Adding a column to a pivot
• Reordering columns used in a pivot
• Increasing the maximum number of pivot columns
• Partitioning a non-category pivot column into discrete groups
• Sorting rows in the pivot table
• About the pivot drawer
• Creating a new table from data in the pivot table
• Exporting a pivot table
• About row multipliers (frequency weights)

---

Back to Wizard Help