# Pivoting data

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

Back to Wizard Help