We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Overview

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


Data binding

The pivot grid can be bound to data in the form of JavaScript object array collections. It uses the Essential JS 2 data manager explicitly to handle remote data and data processing.

ArrayCollection

JavaScript array collection

An array of JavaScript objects can be bound to the pivot grid, allowing it to work smoothly in applications.

RemoteDataBinding

Remote data binding

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.


Summary exploration

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.

SummaryExploration


Data manipulation

Filtering

Filtering

Allows users to view only specific/desired records in the component by excluding other records.

Sorting

Sorting

Allows users to order both fields and values (column) either in the ascending or descending order.

Aggregation

Aggregation

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.


Pivot field list and grouping bar

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.

PivotFieldList


Calculated field

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.

CalculatedField


Frozen header

By default, row and column headers are frozen to allow scrolling and comparing cell values with the corresponding row and column headers.

FrozenHeader


Column

Resize

Resize

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.

Reorder

Reorder

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.


Optimized for mobile devices

Built_Themes

Touch support

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.

Responsiveness

Responsiveness

Responsive features allow the pivot grid layout to be viewed on various devices.

AdaptableFieldList

Adaptable field list UI

It allows the pivot field list to be viewed on various devices.


Exporting

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.

Exporting


Globalization and localization

Globalization

Globalization

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.

RTL

Right to left {RTL}

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.

Localization

Localization

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.


45+ ASP.NET CORE CONTROLS

Transform your applications today by downloading our free evaluation versionDownload Free Trial

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.