What it means
Pivot turns rows into summary cross-tabs so users can compare totals by dimension instead of reading each record individually.
Data Models guide
Pivot data grid documentation
Pivot turns row data into summary cross-tabs. This page focuses on the client-side pivot contract: grouped dimensions, pivoted dimensions, aggregated values, and the generated field keys that come back through the callback.
When to use it
Use it for analytical screens where the main question is about grouped totals, comparisons, or cross-sections. Avoid it on pages where users still need direct row editing or detailed row-by-row review.
Implementation notes
Choose value columns and aggregation functions that users already expect from spreadsheets or BI tools. Use `onPivotResultFieldsChange` when the host needs to inspect the generated field keys or reflect them in other UI.
Relevant API
Start with pivot.enabled, pivot.groupColumns, pivot.pivotColumns, pivot.valueColumns, pivot.pivotMode, pivot.resultFieldSeparator, pivot.onPivotResultFieldsChange. Open the live API reference for types and defaults.