📊Pivot Table
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
Common mistake
Key takeaways
- 1Rows and columns. Pick a field for each side.
- 2Totals in cells. Each cell sums the rows that match.
- 3Drag to ask again. Move a field to ask a new question.