Summarize data with a pivot table

Group records into rows and show counts, sums, averages, minimums or maximums in a Pivot Table, with totals, sorting, filter tabs and drill-down.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. How a pivot table is built
  2. Add a Pivot Table
  3. Rows
  4. Columns and calculations
  5. Title, sorting and drill-down
  6. Filter the records
  7. Common problems

A Pivot Table groups the records of a table by one or more fields and shows a calculated value for each group, such as the number of jobs per status or the total invoice amount per customer. People can click a row to see the records behind it.

How a pivot table is built #

PartWhat it isExample
RowsThe fields records are grouped by. Each distinct value becomes a row.Status
ColumnsThe values calculated for each row: a count of records, or the sum, average, minimum or maximum of a number field.Total Number of records; Sum of Amount
Row SummariesExtra columns that combine the values across each row.Sum of the row's columns
Column SummariesExtra rows at the bottom that combine the values down each column.Grand total

Add a Pivot Table #

  1. Add the component In the Page Builder, click Add Component in a column and choose Pivot Table under Data Components.
  2. Choose the records Under Which records should this pivot table display?, pick the table under Select data table, or records connected to the page's record or to the logged-in user. Click Customize.
  3. Add rows On the Pivot Table tab, under Rows, choose the Field to group by. Click Add Row to group by another field inside the first.
  4. Add columns Under Columns, choose Total Number of records or a number field and its calculation. Click Add Column for more.
  5. Add totals (optional) Click Add row Summary or Add Column Summary.
  6. Check the preview and save The preview on the right updates as you go. Click Update & Save.
The Pivot Table tab with Rows, Columns, Row Summaries, Column Summaries and Options on the left and a preview on the right

Rows #

SettingWhat it does
FieldThe field to group by.
LabelThe column heading for this field in the pivot table.
Include BlankShow (default) adds a row for records where the field is empty; Hide leaves them out.

You can group by Text, Text Formula, Number, Currency, Basic Formula, Complex Formula, Date, Time, Date/Time, Checkbox, Radio, Select, Decision Box, Rating and Slider fields, Equation fields that return a number, and one-to-one connection fields.

Columns and calculations #

SettingWhat it does
Field/CalculationsTotal Number of records counts the records in each row. Or pick a Number, Currency, Basic Formula, Complex Formula, Rating or Slider field, or an Equation that returns a number, and choose Sum, Average, Minimum or Maximum.
LabelThe column heading.

Row Summaries and Column Summaries each have a Calculations choice (Sum, Average, Minimum or Maximum) and a Label. A row summary adds a column that combines each row's column values; a column summary adds a row under the table that combines each column's values.

Title, sorting and drill-down #

Under Options on the Pivot Table tab:

OptionWhat it does
Pivot Table TitleThe heading shown above the table.
Sort BySort by any row field or column, ASC or DESC. Add New Sort adds a second sort for ties.
Side Panel ViewShow opens a panel listing the records behind a row when someone clicks it. Load More in the panel loads more records. Side Panel Size: Small, Medium (default), Wide or Extra Wide.
Popup ViewWith the side panel on: Show lets people click a record in the panel to open it in a popup.

Turning these on adds a Side Panel View tab and a Popup View tab, where you lay out the fields shown for each record, in rows and columns like a Details component.

Filter the records #

  • To always leave records out, use Filters on the Data Source tab. See Filter the records a component shows.
  • To let people switch between preset views, open the Filters tab, turn on Filter Tabs and click Add New Tab for each view. A Clear Filter tab is added unless you tick Hide Clear Filter Tab in the gear menu.

Common problems #

What you seeWhat to do
A field is missing from the Field list under Rows or ColumnsIts field type cannot be used there. See the lists above.
Totals look wrongCheck the calculation of each column: Average and Sum give very different results. Records with an empty group field form their own row unless Include Blank is Hide.
The live page shows a plan messageYour plan does not include the Pivot Table.

Was this page helpful?

Something wrong or missing on this page? Tell us.