If you have ever spent an hour copying numbers into a summary table, a pivot table will feel like a small miracle. It summarizes thousands of rows in seconds, and you can rearrange it by dragging fields around. Here is how it works, without the jargon.
What a pivot table does
A pivot table takes a long list of records (for example, every order) and groups them into a compact summary (for example, revenue per product per month). It does not change your original data. It is a flexible view on top of it.
The four boxes
| Area | What it does | Example |
|---|---|---|
| Rows | Items listed down the left side | Product |
| Columns | Items listed across the top | Month |
| Values | The numbers being calculated | Sum of Revenue |
| Filters | Limit what is included | Region = West |
Build your first one
- Click anywhere inside your data. Make sure every column has a header.
- In Excel choose Insert → PivotTable; in Google Sheets choose Insert → Pivot table.
- Drag Category to Rows.
- Drag Revenue to Values. It should show "Sum of Revenue".
- Drag Month to Columns.
You now have a category-by-month revenue grid. Sort it from largest to smallest to see what matters most.
Questions a pivot table answers quickly
- Which sales channel brought the most orders this quarter?
- What is the average order value by region?
- How many support tickets did each team close per week?
- Which marketing campaign had the highest spend?
Useful tricks
Change the calculation
Values default to Sum, but you can switch to Count, Average, Min or Max. Count of Order ID gives you number of orders.
Show values as a percentage
"Show values as → % of grand total" reveals each product's share of revenue.
Group dates
Group daily dates into months or quarters to see trends instead of noise.
Common mistakes
- Forgetting to refresh after the data changes.
- Blank cells in the Values column, which can turn Sum into Count.
- Merged cells or multi-row headers in the source data.
Once your pivot table answers the question, add a chart and a two-sentence summary. That is the full loop we practice in Week 1. When you are ready to present it visually, see how to build your first business dashboard.
