RevoGrid Pro / Pivot

Multidimensional analytics, embedded.

Ship spreadsheet-style pivot analysis inside your application. Let users group, filter, aggregate, visualize, and export large datasets without leaving the page.

Explore the live pivot demoRead implementation docs

Drag-and-drop dimensionsMulti-level aggregationHeatmap cell renderingClient-side on 350K+ rows

pivot-analytics.revogrid.ts

350K+rows client-side

Anydimension combination

8aggregation types

0server round-trips

Features

A production-ready pivot table for web apps.

More than a summary panel. RevoGrid Pivot combines a full pivot engine with RevoGrid's high-performance rendering core for interactive product analytics.

DnD

Drag-and-Drop Dimensions

Move fields between Rows, Columns, Data, and Filters slots at runtime so users can reshape reports instantly.

Drag fieldsRuntime pivotZero reload

SUM

Multi-Level Aggregation

Calculate sum, average, count, min/max, median, or custom metrics. Apply multiple aggregations to the same field.

SUM / AVG / CNTCustom agg fnMulti-agg

MAP

Heatmap Cell Rendering

Highlight trends and outliers with built-in value-based color coding, configurable thresholds, and custom color scales.

Heatmap cellsColor scalesThreshold config

ROW

Row & Column Grouping

Build nested row and column hierarchies from any dimension field. Subtotals and grand totals are computed automatically.

SubtotalsGrand totalNested groups

CPU

Client-Side at Scale

Keep pivot interactions responsive without server round-trips. Bind the pivot config directly and aggregate against the grid source.

const plugins = [PivotPlugin]

const pivot = {

  rows: ['City', 'Membership Type'],

  columns: ['Discount Applied'],

  values: [{ prop: 'Total Spend', aggregator: 'sum' }],

} satisfies PivotConfig

<RevoGrid plugins="plugins" pivot="pivot" />

350K rowsIn-memoryPivotPlugin

CSV

Export to Excel / CSV

Give customers downloadable reports with headers, subtotals, and formatted values from filtered or fully pivoted views.

XLSX exportCSV exportFormatted values

Use Cases

What teams build with it.

RevoGrid Pivot ships inside BI dashboards, analytics products, financial reporting tools, and data-heavy internal apps.

01

Revenue Analytics

Slice revenue by segment, region, channel, and time period. Drill from quarterly to weekly with nested row grouping.

Revenue by segment and channel

Drill-down grouping

YoY comparison columns

SUM / percent change / growth agg

02

Customer Analytics

Pivot customer data by membership, spend, and behavioral metrics. Heatmap ratings across segments for instant insight.

Membership tier by city pivot

Avg rating heatmap

Spend distribution

Filter by discount applied

03

Financial Reporting

P&L, cost center analysis, and budget vs actuals in a live, filterable pivot table embedded in your app.

Budget vs actual

Cost center by department

Multi-currency aggregation

Export to Excel for finance teams

Included in RevoGrid Pro Advanced

Pivot is part of the Pro Advanced bundle.

One Pro Advanced license gives your team Pivot Tables, Gantt charts, the full Plugin API, typed source access, and direct engineering support. No per-feature upsell.

See Pro Advanced pricingExplore Pro bundle

Pro Advanced from

$499

/developer/year

+Pivot Tables

+Gantt and dependencies

+Plugin API

+Typed source access

+Engineering support

Embed pivot analytics in your product.

Add a client-side pivot table component to React, Vue, Angular, Svelte, or vanilla JavaScript apps. Included in Pro Advanced.

Open pivot demoView Pro pricing