Glossary · Phase 3 · Machine learning
Pivot table
A summary table with one column's values down the side, another's across the top, and a total or average in each cell.
Try it now
Nine example order lines. Grouped by store, the count of revenue counts lines, not orders: Portland shows 3 lines from only 2 orders. Group by order_id to see which orders have several lines, then try sum and mean, grouped by member.
Learn it properly
Grouping, pivoting and reshaping · Named aggregation, pivot tables, transform, running totals and groups too small to rank. About 45 minutes.
Never trained an AI?
Teach a small one to write, right in your browser. It takes about 20 seconds and needs no account.