# Pivot Table

> A grid that sums up a long list. The rows and columns are fields you pick.

**Field:** Data Engineering  
**Category:** Analytics & BI  
**Also known as:** PivotTable, Crosstab

## Think of it like

It is like sorting a jar of coins into piles by type. Then you count each pile.

## Definition

A pivot table turns a long list of rows into a small grid of totals. You pick one field for the rows, such as region. You pick another for the columns, such as product. Each cell then adds up the values that match both. You can drag fields around to ask a new question in seconds.

## Example

Emma has 5,000 sales rows. A pivot table shows total sales for each of 3 regions and 4 products, in a grid of 12 cells.

## Why it matters

It answers questions like sales by region in seconds. There is no formula to write.

## Common mistake

Forgetting to refresh it after the data changes. The grid keeps the old totals until you do.

## Three principles

- **Rows and columns.** Pick a field for each side.
- **Totals in cells.** Each cell sums the rows that match.
- **Drag to ask again.** Move a field to ask a new question.

## Related terms

- [Drill-Down](https://learn.benibix.com/term/data/drill-down)
- [OLAP Cube](https://learn.benibix.com/term/data/olap-cube)
- [Report (Analytics)](https://learn.benibix.com/term/data/report)
- [Measure (Analytics)](https://learn.benibix.com/term/data/measure)
- [Ad Hoc Query](https://learn.benibix.com/term/data/ad-hoc-query)

![On the left, a list of six sales rows, each with a region, a product and an amount. An arrow marked pivot leads to a grid on the right with North and South as rows and Shoes and Hats as columns. Each cell holds a total, with row and column totals at the edges. The North and Shoes cell, 50, is highlighted, with a note saying 30 plus 20 is 50.](https://learn.benibix.com/diagrams/dat-pivot.svg)

---

Source: https://learn.benibix.com/term/data/pivot-table
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
