The pivot table is a multi-dimensional data visualization component built on top of relational data sources. Pivot report can be managed dynamically at runtime along with other capabilities like aggregation, filtering, and sorting (field and value based).
Binding the pivot table with RESTful services allows data from services to be consumed using the Essential JS 2 data manager explicitly. It supports various data adaptors such as JSON, OData, ODataV4, URL, and Web API for working with a particular data service.
Pivot table provides built-in drill down and drill up capability to visualize data both in detailed view and abstract view, respectively. By default, pivot table displays data in a summarized format.
The high-performance pivot grid allows users to load large amounts of raw data, aggregate it, and view it on-demand through horizontal and vertical scrollbar options with ease.
Filtering allows users to view only specific records in the control using complex filter criteria with the help of member, label, or value filter options, similar to Microsoft Excel.
Allows users to order both fields and values (column) either in the ascending or descending order.
Users can perform calculation over a group of values using the aggregation option. By default, values are summed. The other aggregation types include average, minimum, maximum and count.
The field list and grouping bar are automatically populated with the fields from the assigned report. They later allow end users to drag fields, filter, and sort them, and also create pivot views at run time.
New value field(s) can be added based on a simple mathematical formula to their report either through built-in dialog at run-time or through code behind.
By default, row and column headers are frozen to allow scrolling and comparing cell values with the corresponding row and column headers.
Conditional formatting allows users to apply styles to value cells by changing grid cells’ font style, font color, background color, and font size.
Resizing allows changing column width on the fly by simply dragging the right corner of the column header. The scroll bar will appear when the pivot table content width exceeds the element width.
Columns can be reordered either through user interaction or programmatically. Simply dragging and dropping a column header into the desired column position will reorder the columns.
All pivot table features will work on touch devices with ease. Features such as drill up/down, filtering, sorting, and report manipulation can be done on the fly.
Responsive features allow the pivot table layout to be viewed on various devices.
It allows the pivot field list to be viewed on various devices.
Exports pivot table data to Excel, PDF, and CSV formats. The exported document can also be customized to add header, footer, and its cell properties like type, style, and position programmatically.
Enables users from different locales to use pivot table by formatting the date, currency, and numbering to suit locale preferences. This uses the Essential JS 2 internalization library for handling value formatting.
Supports right-to-left rendering, allowing the text direction and layout of the pivot table to be displayed from right to left. This improves user experience and accessibility for RTL language users.
All the pivot table strings in the user interface can be localized as needed. The pivot table uses Essential JS 2 localization library to localize UI strings.