The pivot grid 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 grid 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 grid provides built-in drill down and drill up capability to visualize data both in detailed view and abstract view, respectively. By default, pivot grid displays data in a summarized format.
Allows users to view only specific/desired records in the component by excluding other records.
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.
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 grid 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 grid 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 grid layout to be viewed on various devices.
It allows the pivot field list to be viewed on various devices.
Exports pivot grid 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 grid 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 grid to be displayed from right to left. This improves user experience and accessibility for RTL language users.
All the pivot grid strings in the user interface can be localized as needed. The pivot grid uses Essential JS 2 localization library to localize UI strings.