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
- 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