Every pivot table grows from the same raw shape: a range in which each column carries one heading and each row records one event, such as a sale, a support ticket or a timesheet entry. Microsoft asks for a single header row; Google Sheets wants a heading on every column before it will build anything. From that list the tool offers four drop zones. Fields placed in rows and columns become the grouping, fields placed in values are counted, summed or averaged, and filters narrow the whole view. Dragging a field from one zone into another is the pivot that gives the feature its name, and it is why an analyst can answer five different questions from one source in a few minutes.
What each suite calls it
- Microsoft Excel writes it as one word, PivotTable, and offers the PivotChart as a chart bound to the same summary.
- Google Sheets says pivot table and opens it from the Data menu, with a side panel for rows, columns, values and filters.
- LibreOffice Calc called it DataPilot for years and now says pivot table; its layout dialog names the zones filters, row fields, column fields and data fields.
Refresh, and guard the source
Two habits separate a trustworthy summary from a fragile one. The first is refreshing: Microsoft documents a manual Refresh command and an option to refresh when the workbook opens, and LibreOffice has its own Refresh entry, so a report sent without one can still show last week's totals. The second is guarding the source where people type into it, which is the job of data validation: a drop-down that offers only North, South, East and West stops one region turning into three rows spelled three ways.
The grouping logic itself is older than spreadsheets; a GROUP BY in SQL does the same thing on a database, and larger data analysis work repeats it at scale. The spreadsheets topic covers the surrounding skills, from formulas to charts.