The pivot grid control is a powerful pivot table implementation for visualizing relational data sources in a multidimensional UI. The pivot grid, as the name implies, pivots data to organize it in a cross-tabulated form. Along with pivoting, summarizing and grouping are also supported.
Pivot grid can load a large set of records on demand in little time.
Pivot grid performs long-running operations asynchronously on a background thread. This allows end users to access other UI controls without distraction.
Improved scrolling means a value only updates in the respective pivot grid view when the end user releases the scroll thumb.
The pivot grid control simulates the pivot table feature of Excel. The data source for the pivot table should be either an IEnumerable list or a data table.
Pivot grid control supports drill up and drill down to visualize the pivot information in both abstract and detailed views.
The pivot table field list and grouping bar of pivot grid control are automatically populated with fields from the bound data source. They later allow end users to drag fields, filter and sort them, and create pivot views at runtime.
Pivot grid supports editing values at runtime, thereby updating the total cell simultaneously.
Pivot grid supports updating values in real time by pushing the live data and refreshing the control whenever it’s required.
Built-in normal and Excel-inspired filter UI with advanced filtering options to easily filter and view data as required. It is also possible to filter programmatically in pivot grid control.
Pivot grid control has support to order rows and columns, either based on labels or values.
Pivot grid supports inserting new calculations at runtime, along with 16 built-in calculation types.
Pivot grid has extensive support for you to define your own custom summaries, along with 10 built-in summary types.
Drill through easily obtains a list of raw items for a particular value cell or summary cell in pivot grid.
This looks like the pivot table in Excel, allowing the end user to pivot rows, columns, and calculations.
Users can customize the pivot grid to look like a flat grid. It allows users to pivot only rows and calculations.
Summary layout easily switches the summary position either to the top or bottom beside each field of pivot grid.
Settings in the pivot grid control can be serialized to an XML format and loaded back through the built-in deserialization options.
Pivot grid allows users to define conditions that, when met, format values’ and summary cells’ font, color, and border settings.
Users are allowed to refresh the pivot grid control only on demand and not during every UI interaction.
There is built-in support for freezing row and column headers for better views of values in pivot grid.
There is a UI option to expand/collapse a header to a certain extent.
Pivot grid retrieves information about a particular cell on hyperlink cell click. It later allows you to perform custom operations programmatically.
There is extensive support to select a range of value cells.
Pivot grid has support to show/hide grand totals and subtotals for rows and columns.
Tooltip provides basic information about a cell in pivot grid while hovering the mouse pointer over it.
Pivot grid has a rich set of options available for exporting data to Excel, Word, PDF, and CSV, and printing the same. Several options are also provided to customize the exporting and printing operations.
Pivot grid ships with built-in themes like Blend, Office, Visual Studio, and Metro.
Pivot grid provides ability to customize the appearance of the control to any extent programmatically.
Easily customize all aspects of appearance using the theme studio utility.