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 less time.
Perform 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 grid view where 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.
There is built-in support to drill up and drill down to visualize the grid information in both abstract and detailed views.
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.
Edit the values at run time, thereby updating the total cell simultaneously.
Update values in real time by pushing the live data and refreshing the control whenever its 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.
Order rows and columns, either based on labels or values.
There is extensive support to insert new calculations at run time, 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.
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 top or bottom beside each field.
Settings in the pivot grid control can be serialized to a 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.
Users are allowed to refresh the 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.
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 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.