Pivot Tables¶
The Pivot Table Builder lets you summarize large datasets by grouping, filtering, and aggregating data interactively. Results can be output to a new sheet or a specific location.
Opening the Pivot Table Builder¶
Open it via Data > Pivot Table in the menu bar, or use the toolbar button. The current selection is auto-filled as the source data range.
Source Data¶
Enter a range in the format Sheet1!A1:F100. The first row of the range must contain column headers. Click Load to read the data and populate the available fields.
Field Wells¶
After loading, drag field chips from the Available Fields area into one of four wells:
| Well | Purpose |
|---|---|
| Rows | Group data by these fields (row labels in the output). |
| Columns | Create column groupings (cross-tabulation). |
| Values | The fields to aggregate. Each value field has a configurable aggregation function. |
| Filters | Restrict the source data before aggregation. Click the dropdown arrow on a filter chip to select/deselect specific values. |
Fields can be moved between wells by dragging, and removed by clicking the X on a chip.
Aggregation Functions¶
For each value field, choose one of:
- SUM (default) -- total of all values
- COUNT -- number of non-empty values
- COUNTA -- count of all values including empty
- AVERAGE -- arithmetic mean
- MIN / MAX -- smallest or largest value
Change the function using the dropdown on the value chip.
Live Preview¶
A preview table renders below the wells as soon as at least one value field is assigned. The preview updates instantly when you change fields, filters, or aggregation functions.
The preview includes:
- Subtotals per group (when multiple row fields are used)
- Grand total row and column
Output Options¶
- New Sheet: Creates a fresh sheet and writes the pivot table starting at A1.
- Specified Location: Enter a cell reference like
Sheet2!A1to write results to an existing sheet.
Click Generate Pivot Table to write the results. Click Refresh to update an existing output after the source data changes.
Serialization¶
The pivot table configuration (source range, field assignments, filter selections, output location) is saved as part of the workbook and restored on load.