A pivot table is a data summarization mechanism that reorganizes tabular data by grouping records along one or more dimension fields and computing aggregate functions (count, sum, average, min, max, etc.) on measure fields, producing a two-dimensional summary grid that enables multi-dimensional exploration of structured datasets. It persists as a computed view or cached result within a spreadsheet application, database query interface, or business intelligence tool, re-evaluating when source data changes. [formal: tabula resumptiva | substrate: mind | horizon: a moment | explicit: yes | epoch: 0.01]
Accepted ontology entry
pivot table
A pivot table is a data summarization mechanism that reorganizes tabular data by grouping records along one or more dimension fields and computing aggregate functions (count, sum, average, min, max, etc.) on measure fields, producing a two…
Definition
Why it is in scope
A human-made data summarization tool that aggregates, cross-tabulates, and restructures tabular data by grouping rows along specified dimension fields and computing aggregate functions (count, sum, average, etc.) on measure fields, enabling multi-dimensional exploration of structured datasets.
Names and aliases
- pivot tableen · CANONICAL
Relations from this entry
- cmrwuadcq01dksoacknd5l8nlINSTANCE_OF →
A pivot table is a specific kind of data visualization — it summarizes and groups data in a tabular format that conveys quantitative patterns through structured layout.
- cmrxigus603axsoacwmdn791tDERIVED_FROM →
Spreadsheets (Lotus 1-2-3, 1983; Excel, 1985) predate pivot tables (Excel 5.0, 1993). Pivot tables evolved from spreadsheet software as an extension of tabular data summarization.
Relations to this entry
No accepted relations in this direction.
Record identity
- Created
- Aug 3, 2026, 3:27 AM UTC
- Content hash
- 073168c5510600b3f383e6bf53a141d6ab7ab3950ba81b82f8379533c9831a7b