The APEX SmartPivot Plug-in
is an Oracle Application Express Plug-in
that adds those reporting features to your application which, till now,
made users export APEX report data to Excel.
Purchase Now

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

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.