Give us feedback
Reactive icon

Pivot Table

version 1.0.0 (Compatible with OutSystems 11)
Uploaded on 04 November 2019 by 
Gonçalo Borrêga
 (1 rating)

Pivot Table

Allow your business users to explore data through pivot tables, in a drag'n'drop UI similar to that found in popular spreadsheet programs.
Read more

Reactive Web component that allows to easily create an editable Pivot Table that your end users can use to manipulate and look into data.

It wraps PivotTable.js, which implements a pivot table drag'n'drop UI similar to that found in popular spreadsheet programs. You can drag attributes into/out of the row/column areas, and choose a summary function. You can also preconfigure the pivot table and make it readonly, for a static cross-tab like display.

This component allows easily binding your data to the pivot table, through an easy to bind object, converted to JSON. Check the demo module to learn how to use it.

The sample module shows some of the configurations you can make, such as:

  • Define which columns/rows show up by default on the report
  • Define which aggregators are performed (e.g. Count, Sum(Price), List Unique Values)

Features still in development: 

  • Creating "Bins" for grouping dimensions (e.g. Age groups, instead of individual Age data points). Date bins (e.g. Years, Months, Quarters, etc. coming)
  • Predefined Sorting by Totals, Columns or Row aggregators (from NReco PivotTable extensions)
  • Saving pivot table current state allowing you to build a set of custom reports
  • Being notified on which cells get clicked to show drill down detail.

The look and feel of the table is customizable by CSS.
Check PivotTable.js wiki in case you need to go deeper

Release notes (1.0.0)
Reviews (1)
in version 1.0.0
Is there anyway we could obtain some documentation for utilisation of this Pivot Table with Reactive Outsystems Screens.

I've spent a day trying to figure it all out, but I have not succeeded. Is there a paid version I am supposed to purchase, where support is available. Please let us know. many thanks.