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