Skip to content
BENIBIX Learn

Pivot Table

Data📊 Analytics & BIBusiness Intelligence (BI)

Also known as PivotTable, Crosstab

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

Think of it like

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

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.

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.
Six rows become a grid. Each cell adds up the rows that share its region and product.

Common mistake

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

Key takeaways

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