Pivot Grid

Note

Pivot turns a list of records into an interactive summary. For example, group orders by region, compare quarters, and add up sales. You choose the fields; Pivot builds the report.

Choose Sales by region, Sales by product, or Sales by quarter. The same six orders are grouped differently, and the total stays $1,000.

Interactive example

Explore sales

Six orders, different perspectives. Choose how to group sales — Pivot adds up the totals.

The example loads when visible.

Reset

Start here

Your goal	Start with
Understand Pivot tables	What is Pivot?
Understand rows, columns and values	Read a Pivot table
Add Pivot to an application	Your first Pivot
Let users change the report	Explore the interface
Calculate reports on a backend	Server-side overview and setup
Configure or read a report with AI	AI Assistant
Visualize a report	Pivot Charts

Build your report

Start with fields and aggregations, then add totals, sorting, filters, and drill-down. Save reports so users can return to their work, or export the results.

More guides and integration choices

Choose Your Integration

Most applications start with PivotPlugin and the direct grid.pivot configuration. React, Vue and Angular use the same data and configuration through their grid wrapper.

For specialist integrations, use the installed plugin’s authoring controller for a custom interface, or Headless Pivot to calculate without a grid. These are separate ownership choices; you do not need them to build your first table.

Core Vocabulary

A field is a property in your records. A row field groups records vertically; a column field creates a horizontal breakdown. A measure calculates a value such as total sales. Read the illustrated explanation.

Mental Model

Source records → choose groups → calculate summaries → display the report. The backend can calculate the summaries when your data should stay on the server.

First Working Pivot

Follow Your first Pivot for complete setup and a live example.

How To Read A PivotConfig

Learn rows, columns and values first. The configuration reference lists every option.

What RevoGrid Pivot Owns

Pivot owns the grid’s displayed report while active. Your application keeps the original records. Read lifecycle and updates when connecting application state.

Feature Map

The feature directory distinguishes supported behavior from application responsibilities. See compatibility and migration before upgrading an existing integration.

When To Use Pivot

Use Pivot to answer grouped questions such as sales by region, incidents by team, or average delivery time by month. Use a regular grid when people mainly inspect or edit individual records.

Conceptual Foundations

What is Pivot? → rows, columns and values → prepare your data.

Recommended Reading Order

Your first Pivot → explore the interface → choose fields → add Pivot Charts.