Data Models guide

SSRM Pivot data grid documentation

Use SSRM pivot when the server owns the cross-tab result.

What it means

SSRM pivot lets the grid ask for a pivoted result set while the server stays responsible for grouped totals and generated field keys.

When to use it

Use it when pivoted cross-tabs come from backend queries or warehouse-style endpoints instead of being computed in the browser. Reach for this when the pivot result set or grouped source data is too large for client-side pivoting.

Implementation notes

Server-side pivoting needs both the pivot request config and an `onPivotResultFieldsChange` handler in the host. The host uses those returned field keys to build the visible pivot columns before the rows can render meaningfully.

Relevant API

Start with serverRowModel.getRows, serverRowModel.pivot, serverRowModel.pivot.enabled, serverRowModel.pivot.groupColumns, serverRowModel.pivot.pivotColumns, serverRowModel.pivot.valueColumns, serverRowModel.pivot.pivotMode, serverRowModel.pivot.resultFieldSeparator. Open the live API reference for types and defaults.