Pivot Table

Stable Version 2.0.1 (O10)
Also available for 9.1
Published on 05 October 2017 by 
Created on 19 December 2015
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

PivotTable.js 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 makes it very simple to use the library (PivotTable.js), using as datasource either data on the screen inside a TableRecord, or accessed from a REST API you create with the platform.

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

  • Creating "Bins" for grouping dimensions (e.g. Age groups, instead of individual Age data points). Date bins (e.g. Years, Months, Quarters, etc. coming)
  • Define which columns/rows show up by default on the report
  • Define which aggregators are performed (e.g. Count, Sum(Price), List Unique Values)
  • 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

What’s new (2.0.1)

Fixed problem where ReadOnly view was not properly considering the Aggregator/Values nor the renderer.

  • This now also allows saving your settings in Edit mode, and then switching to ReadOnly mode while keeping the exact same configuration - useful for a user to change a report, and then save it for clean visualization by someone else.
Reviews (1)
in version 2.0.1
Good tool. The REST version example is not complete, but you can look for the "parliament" example to see all.
As a suggestion, good idea if can show/hide the total column/line. Some times we do not want to totalize the column/line.
Great tool!
UI & Widgets, Reporting
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Gonçalo Borrêga who created this component.
Pivot Table has no dependencies.
Component Consumers
No consumers yet.
Weekly Downloads 
Related Components
Silk UI Web
OutSystems R&D
A fully responsive and beautiful UI framework that works within the OutSystems Platform. Build amazing looking applications, in a fraction of the time, which work perfectly across devices. Learn how to start using Silk UI and see the examples at silkui.outsystems.com . Obtain assistance on using Silk UI in our forums .
Guilherme Pereira
Simple to use html to pdf/image converter. Based on wkhtmltopdf (https://wkhtmltopdf.org/)
Multiple File Upload
Multi Uploaders
Allow you to upload multiple files in one upload form or using drag and drop functionality.
More from Gonçalo Borrêga
XML Records
Afonso Carvalho
An extension that allows you to convert an hierarchical structure, composed of Records and/or RecordLists to XML. It also allows to read an XML into the structure
A collection of reusable actions to help us stop reinventing the wheel. Join the team and bring your own top reused actions to the community!
Wisdom of the Crowds
Rodrigo Castelo
This application is an online brainstorming tool that allows you to collect in one place the brainpower of several people.