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.
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.
The pivot table field list and grouping bar are automatically populated with the fields from the bound data source. They later allow end users to drag fields, filter and sort them, and create pivot views at run time.
A built-in filter UI allows you to easily filter and view data. It is also possible to filter programmatically.
Order rows and columns based on headers.
There is built-in support to drill up and drill down to visualize the grid information in both abstract and detailed views.
Along with 16 built-in calculation types, there is also extensive support to insert user-defined calculated fields using a custom formula, either dynamically at runtime or programmatically.
Pivot grid has extensive support for you to define your own custom summaries for the pivot item values using a built-in dialog at runtime as well as programmatically. It also supports 19 other built-in summary types to customize the summaries.
Edit the values at runtime, thereby updating the total cell simultaneously.
Update values in real time by pushing the live data and refreshing the control whenever required.
Perform long-running operations asynchronously on a background thread. This allows end users to access other UI controls without distraction.
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. This allows users to pivot only rows and calculations.
Pivot grid has support to show or hide grand totals and subtotals for rows and columns.
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 value and summary cells’ font, color, and border settings.
There is built-in support for freezing row and column headers for better views of values.
There is extensive support to select a range of value cells.
Tooltips provide basic information about a cell while hovering the mouse pointer over it.
Pivot grid retrieves information about a particular cell on hyperlink cell click. It later allows you to perform custom operations programmatically.
Users are allowed to refresh the control only on demand and not during every UI interaction.
Pivot grid has a rich set of options available for exporting data to Excel, Word, and PDF, and printing the same. Several options are also provided to customize the exporting and printing operations.
Every static text in the pivot grid and built-in dialogs can be localized to any desired language.
Pivot grid can render headers and values from right to left to adhere to certain local standards.
Pivot grid ships with built-in themes like Blend, Office, Visual Studio, and Metro.
Customize the appearance of the control to any extent programmatically.