Introducing Preset's Interactive Pivot Table
At Preset, we’re always looking for ways to make data exploration easier and more interactive. Earlier this year, we introduced the Interactive Table, which added multi-column filtering, resizing, pinning, easy exports, and drag-and-drop column rearrangement to a familiar table view.
Now, we’re bringing that same interactivity to pivot tables. Meet the Interactive Pivot Table —powered by AG Grid Enterprise.
What the Interactive Pivot Table Can Do
The Interactive Pivot Table is designed to make pivoting as smooth and intuitive as working in a spreadsheet, with the added power of Preset.
- Sort and filter columns directly in the pivot table.
- Drag-and-drop to rearrange fields
- Drag-and-drop to rearrange row groups or values — explore your data or rearrange your pivot table in seconds
- Collapse and expand row groups and preserve the view you set up in Chart Builder in your dashboards
- Pin columns so they stay in view while scrolling
- Switch value aggregations — quickly toggle between sums, averages, counts, and more.
Anyone viewing the Interactive Pivot Table in a dashboard can take these actions, giving your team more powerful exploration abilities.
Feature Comparison
| Feature | Pivot Table | Interactive Pivot Table |
|---|---|---|
| Drag-and-drop field rearrangement | No | Yes |
| Multi-column sorting & filtering | Yes, when building or editing charts | Yes, supported in chart or dashboard view |
| Show/hide columns | No | Yes, when building or editing charts |
| Pin columns | No | Yes |
| Change aggregations on the fly | No | Yes |
| Change page size | No | Yes |
| Dashboard user interactivity | No | Yes |
Video Demo
How to Upgrade your exisiting Pivot Tables
- Open any existing Pivot Table chart in the Chart Builder.
- Switch your chart type and choose Interactive Pivot Table
- Click Update Chart.
