# 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.

Source: https://tadabase.com/docs/pages/pivot-tables-complete-guide  
Status: Verified Nov 17, 2026. Checked against the current product

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.

> **Note:** The Pivot Table needs a plan that includes it. Without it, the settings window shows an **Upgrade** button, and the live app shows a plan message instead of the table.

## How a pivot table is built

| Part | What it is | Example |
| --- | --- | --- |
| **Rows** | The fields records are grouped by. Each distinct value becomes a row. | Status |
| **Columns** | The 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 Summaries** | Extra columns that combine the values across each row. | Sum of the row's columns |
| **Column Summaries** | Extra 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](https://tadabase.com/docs-shots/pages-pivot-table-builder.webp)

## Rows

| Setting | What it does |
| --- | --- |
| **Field** | The field to group by. |
| **Label** | The column heading for this field in the pivot table. |
| **Include Blank** | **Show** (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

| Setting | What it does |
| --- | --- |
| **Field/Calculations** | **Total 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**. |
| **Label** | The 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:

| Option | What it does |
| --- | --- |
| **Pivot Table Title** | The heading shown above the table. |
| **Sort By** | Sort by any row field or column, **ASC** or **DESC**. **Add New Sort** adds a second sort for ties. |
| **Side Panel View** | **Show** 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 View** | With 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](https://tadabase.com/docs/pages/data-source-filtering).
- 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 see | What to do |
| --- | --- |
| A field is missing from the **Field** list under **Rows** or **Columns** | Its field type cannot be used there. See the lists above. |
| Totals look wrong | Check 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 message | Your plan does not include the Pivot Table. |
