A pivot table your users can build themselves
Drag fields into rows, columns and values and watch the crosstab rebuild. Aggregation runs in an embedded Web Worker, so the interface stays responsive while it counts.
Drag a field. The numbers follow.
Three fields is a working pivot
npm install @kanunilabs/pivotgrid-reactimport { BasePivotGrid } from '@kanunilabs/pivotgrid-react';
import '@kanunilabs/pivotgrid-react/styles.css';
<BasePivotGrid
dataSource={rows}
fields={[
{ dataField: 'region', area: 'row' },
{ dataField: 'quarter', area: 'column' },
{ dataField: 'revenue', area: 'data', summaryType: 'sum' },
]}
/>The three aggregation workers are compiled into the package and started from a Blob URL — there is no workerUrl to set and no file to copy into public/.
What is free, and what is not
In the free edition
- Drag fields between row, column, value and filter areas
- Sum, average, min, max, count and distinct aggregation
- Expand and collapse any node, at any depth
- Percent-of-total, running totals and cell colour scales
- Saved views, six themes and twelve locales (Arabic RTL included)
- CSV and JSON export, and print
Enterprise adds
- Calculated measures, with a visual editor in the footer
- Visual prefilter builder over the source rows
- Drill down from any cell to the rows behind it
- Node context menu: bulk expand and collapse
- Styled Excel and PDF export, with the crosstab structure preserved
- Interactive charts driven by the current pivot
The full wording, with the licence key setup, is in the Enterprise guide.
Before you read the guide
Is this a feature of the data grid, or a separate component?
A separate component with its own package, its own field panel and its own aggregation engine. It is not a mode of DataGrid — but it IS covered by the same licence key, which is the part most competitors charge twice for.
Which frameworks?
React 18+ only. Unlike DataGrid there is no framework-free renderer for PivotGrid today, and no Angular or Vue adapter.
How much data can it aggregate?
Aggregation, sorting and filtering run in a Web Worker that is embedded in the package — nothing to configure. The playground lets you raise the row count and watch the crosstab rebuild, which is a better answer than any number we could put here.
What is free?
Everything listed under "In the free edition" above: the whole drag-and-drop pivoting experience, aggregation, expand/collapse, conditional formatting, saved views, theming, 12 locales and CSV/JSON export. Calculated measures, the prefilter builder, drill-down, charts and styled Excel/PDF export are the paid tier.
One licence covers this and DataGrid
Most vendors sell the pivot as a second product, or fold it into a single expensive tier. Here one key opens both, and the subscription ending does not switch off what you already shipped.