Creating tabulations of counts and descriptive statistics
About the Pivot view
The Pivot view lets you create multi-way tabulations and calculations
About the pivot drawer
The pivot drawer keeps multiple pivots organized
Adding a column to a pivot
Use the controls below the pivot table to manage pivot columns
Creating a new table from data in the pivot table
Use the Copy Table Data button to create a compact representation of the current data table
Creating an aggregation in the pivot table
Use the controls on the left side of the Pivot view to create an aggregation
Creating a new pivot in the Pivot view
Manage multiple pivots using the controls in the pivot drawer
Deleting an aggregation from the pivot table
To delete an aggregation, select it and use the Delete button
Deleting a pivot from the Pivot view
Manage multiple pivots using the controls in the pivot drawer
Changing the aggregate function used in an aggregation
To change the aggregate function, click the function name in the aggregation table
Exporting a pivot table
The pivot table can be exported as CSV, Excel, or JSON using the Table menu
Hiding an aggregation in the pivot table
To hide an aggregation, uncheck the box next to it in the aggregation table
Increasing the maximum number of pivot columns
Use the slider in the Pivot drawer to adjust the maximum number of pivot columns
Partitioning a non-category pivot column into discrete groups
View partitioning options with the Configure button next to the pivot column pop-up button
Reordering columns used in a pivot
Use the controls below the pivot table to manage pivot columns
Sorting rows in the pivot table
Click the header of an aggregation to sort by it; use the check-box to sort within the first pivot column