APEX SmartPivot | Features

Pivot Data Grid

Customizable multilevel pivot data grid to analysis data from any angle.

APEX 5.1+

This Region Plug-In is compatible with APEX versions 21.1 or higher.
The current version is tested against APEX 23.2.

Easy Integration

Enrich any applications with an advanced reporting component users will love to use.

You are a business user and want to analyze your data from your database inside your APEX application, just like in Excel?

The SmartPivot Plug-in enables users to create multi-dimensional pivot reports using drag-and-drop functionality. Easily configure sub- and grand totals just like in Excel, in any APEX application.

Key features of APEX SmartPivot are:

Easily customized pivot grid to analysis data from any angle of views.
Drag and drop column and row selection; mimics all functionalities of Microsoft Excel with an intuitive user interface
Simple drill down into related detail data of any aggregated data point
Filtering
Customizable presentation
Conditional Formatting (new in v1.1)
Automatic creation of chart presentation of aggregated data
Saving and sharing of reports as used to in Interactive Reports
Export to Excel

Screenshots

Drag&Drop data layout

Customizable presentation

Automatic chart presentation

Just provide a single query as Region Source

Users can save and share report layouts

Application Express Developer? Enrich your applications with an advanced reporting component your users will love to use. Easier than adding a classic APEX report.

The SmartPivot APEX Plug-in is easy to install. To create a Pivot report, you just have to provide the query that gets the data. Columns and datatypes will automatically be detected and presented. This Region Plug-In is compatible with APEX versions 5.1 or higher. SmartPivot is much richer and user-friendly than the pivot functionality build into Interactive Reports of APEX.