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.

Pivot Grid

Pivot grid is a powerful pivot table implementation for visualizing relational data in a multidimensional UI. The pivot grid, as the name implies, pivots the data to organize it in a cross-tabulated form. The pivot grid is just like our OLAP grid control, but works with relational data. Our powerful in-memory pivoting engine can transform hundreds of thousands of relational table rows into comprehensible pivot information within seconds. Along with pivoting, summarizing and grouping data are also supported.

Data Source

Pivot grid simulates the pivot table feature of Excel. It accepts any kind of data collection. The major advantage of a pivot grid is that you can extract the desired information from a large list within seconds. Along with presenting data, a pivot grid also enables you to summarize and group data. It is ideal for the financial domain, where it can be used to organize and analyze business data.

Pivot Table Field List

Pivot grid provides a built-in pivot schema designer very similar to Microsoft’s Excel. Pivot grid view can be dynamically built and customized by choosing any available fields to display, and choosing whether those fields should be displayed as column or row values.

Grouping Bar

The pivot grid control’s grouping bar is automatically populated with fields from the bound data source and enables end users to drag fields between different areas such as columns, rows, values, and filters, and create pivot views as they wish.


One of the most important features of the pivot grid is its support for filtering data as it limits the amount of information displayed for better readability. You can apply n number of filtering conditions to the grid at a time. Data will be filtered based on the filter expression specified.


You can simply toggle the sort order by clicking on the field headers in the row and column header area.

Asynchronous Data Processing

The pivot grid control provides support to perform long-running data operations asynchronously (such as loading, filtering, sorting, grouping, etc.) in a background thread, so that users can access other UI controls while the pivot grid is processing.

Conditional Formatting

Conditional formatting changes the appearance of a specified cell range or pivot field based on rules applied by users.


You can select grid cells similar to the cell selection in Microsoft Excel to copy data to the clipboard quickly.


You can enable tooltips for individual cell styles including column header, row header, value cell, summary cell, and summary headers cells.

Cell types, including column headers, row headers, summary headers, summary cells, and value cells, can have hyperlinks.

No results found











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.