Overview of React Pivot Table
The Syncfusion® React Pivot Table provides interactive tools for summarizing, organizing, exploring, and presenting multidimensional data. Use the following feature overview to identify the available capabilities, understand where they apply, and open the corresponding user guide topic for configuration details and limitations.
For supported React and browser versions, refer to the system requirements.
Common use cases
-
Interactive business analysis - Reorganize fields, filter members, drill into hierarchies, and compare aggregated values from different perspectives.
-
Operational and financial reporting - Create summarized reports with calculated fields, conditional formatting, totals, and reusable report layouts.
-
Large dataset exploration - Use virtual scrolling, paging, data compression, or server-side processing to analyze high-volume data.
-
Multidimensional analysis - Connect to OLAP cubes and SSAS data sources to explore measures, dimensions, and hierarchies.
-
Visual reporting - Present summarized data through Pivot Charts and export or print the resulting reports.
Feature overview
The Availability column uses the following terms:
-
Built-in - Works automatically when the relevant view or data structure is present, without a feature-specific property or module.
-
Configurable - Requires feature-specific component properties, injected modules, server endpoints, or services.
-
Integration pattern - Implemented by integrating the Pivot Table with another component or service; it is not a standalone Pivot Table feature.
-
Partial - Qualifies standards conformance rather than the delivery method and indicates documented conformance gaps or limitations.
Feature behavior can differ between relational and OLAP data sources. Review the linked topic before combining features because some options are mutually exclusive or have data-source-specific limitations. For example, virtual scrolling and paging cannot be enabled at the same time.
Data sources
| Feature |
Availability |
Applies to |
Learn more |
| Local JSON data |
Configurable |
Relational |
JSON data binding |
| Local CSV data |
Configurable |
Relational |
CSV data binding |
| Remote JSON and CSV data |
Configurable |
Relational |
Data binding |
| Remote services through data adaptors |
Configurable |
Relational |
Remote data binding |
| OLAP cubes and SSAS through XMLA |
Configurable |
OLAP |
OLAP data binding |
| Server-side pivot engine |
Configurable |
Relational; performs server-side aggregation, filtering, sorting, and grouping |
Server-side engine |
Data analysis
| Feature |
Availability |
Applies to |
Learn more |
| Interactive report reconfiguration (slice and dice) |
Configurable |
Relational and OLAP |
Field List |
| Drill-down and drill-up operations |
Built-in |
Relational and OLAP |
Drill down and drill up |
| Drill through to source records |
Configurable |
Relational; OLAP requires cube drill-through permission and appropriate SSAS roles |
Drill through and OLAP roles
|
| Member sorting |
Built-in |
Relational and OLAP |
Sorting |
| Value sorting |
Configurable |
Relational and OLAP |
Value sorting |
| Member filtering |
Configurable |
Relational and OLAP |
Member filtering |
| Label filtering |
Configurable |
Relational and OLAP |
Label filtering |
| Value filtering |
Configurable |
Relational and OLAP |
Value filtering |
| Calculated fields |
Configurable |
Relational and OLAP; formulas differ by source type |
Calculated field |
| Conditional formatting |
Configurable |
Relational and OLAP |
Conditional formatting |
| Custom, date, and number grouping |
Configurable |
Relational only |
Grouping |
| Aggregation types |
Configurable |
Relational only; OLAP aggregation is defined by the cube |
Aggregation |
Field configuration and report layout
| Feature |
Availability |
Applies to |
Learn more |
| Popup and stand-alone Field List |
Configurable |
Relational and OLAP |
Field List |
| Field search |
Configurable |
Relational and OLAP |
Search desired field |
| Drag-and-drop field arrangement |
Configurable |
Relational and OLAP |
Grouping bar |
| Member editor |
Configurable |
Relational and OLAP |
Filtering |
| Deferred layout update |
Configurable |
Relational and OLAP |
Defer update |
| Compact layout |
Built-in |
Relational and OLAP |
Row and column |
| Classic (tabular) layout |
Configurable |
Relational only |
Classic layout |
| Show or hide subtotals and grand totals |
Configurable |
Relational and OLAP |
Show or hide totals |
For large datasets, choose virtual scrolling, paging, data compression, or the server-side pivot engine based on the data volume, data-source type, and processing requirements. Refer to performance best practices for additional optimization guidance.
| Feature |
Availability |
Applies to |
Learn more |
| Virtual scrolling |
Configurable |
Relational and OLAP |
Virtual scrolling |
| Paging |
Configurable |
Relational and OLAP |
Paging |
| Data compression |
Configurable |
Relational |
Data compression |
Editing
Editing changes the underlying raw records and is available only for relational data sources. The selected data adaptor or server endpoint must also support the corresponding create, read, update, and delete operations.
| Feature |
Availability |
Applies to |
Learn more |
| Normal editing |
Configurable |
Relational only |
Editing |
| Dialog editing |
Configurable |
Relational only |
Dialog editing |
| Batch editing |
Configurable |
Relational only; requires a compatible batch endpoint for remote data |
Batch editing |
| Command columns |
Configurable |
Relational only |
Command column |
| Inline value editing |
Configurable |
Relational only |
Inline editing |
Visualization
| Feature |
Availability |
Applies to |
Learn more |
| Integrated Pivot Chart |
Configurable |
Relational and OLAP |
Pivot Chart |
| Pivot Table, Pivot Chart, or combined view |
Configurable |
Relational and OLAP |
Pivot Chart |
| Multiple chart types |
Configurable |
Relational and OLAP |
Chart types |
| Chart drill interaction |
Configurable |
Relational and OLAP; requires the Pivot Chart module and a hierarchy with child levels |
Drill down and drill up |
| Interactive and customizable legend |
Configurable |
Relational and OLAP |
Legend customization |
Exporting and printing
| Feature |
Availability |
Applies to |
Learn more |
| Toolbar |
Configurable |
Relational and OLAP |
Toolbar |
| Grouping bar |
Configurable |
Relational and OLAP |
Grouping bar |
| Grouping context menu |
Configurable |
Relational only; available items depend on the selected field and enabled grouping settings |
Grouping |
| Touch interaction and mobile-device support |
Built-in |
Relational and OLAP |
Accessibility and touch support
|
| Cell hyperlinks |
Configurable |
Relational and OLAP |
Hyperlinks |
| Cell tooltips |
Built-in |
Relational and OLAP |
Tooltips |
| Flexible width and height |
Configurable |
Relational and OLAP |
Width and height |
| Number, currency, percentage, and custom formatting |
Configurable |
Relational and OLAP |
Number formatting |
| Date and time formatting |
Configurable |
Relational; OLAP member captions and formats are supplied by the cube |
Customize date and time values |
| Theme and style customization |
Configurable |
Relational and OLAP |
Style and appearance |
Report management and globalization
Accessibility
| Feature |
Availability |
Applies to |
Learn more |
| WAI-ARIA roles and attributes |
Built-in |
Component UI |
WAI-ARIA attributes |
| Screen reader support |
Built-in |
Component UI |
Accessibility |
| Keyboard accessibility |
Built-in |
Component UI; some shortcuts require the corresponding feature to be enabled |
Keyboard interaction |
| High Contrast theme support |
Configurable |
Component UI |
Themes |
| WCAG 2.2 and Section 508 alignment |
Partial |
Component UI |
Accessibility compliance |
AI-assisted report configuration
AI assistance is an application integration pattern rather than a built-in Pivot Table engine capability. The reference implementation combines Pivot Table with AI AssistView and a secured server-side large language model integration.
| Feature |
Availability |
Applies to |
Learn more |
| Natural-language report configuration |
Integration pattern |
Operations allowed by the application’s validated action contract |
Smart Pivot Table |
| AI-assisted filtering, sorting, aggregation, layout, and chart changes |
Integration pattern |
Operations allowed by the application’s validated action contract |
Supported AI operations |
Quick links