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 Table) Control for WPF

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.

WPF pivot grid control


High performance

On-demand loading support in WPF pivot grid control

On-demand loading

Pivot grid can load a large set of records on demand in little time.

Asynchronous loading support in WPF pivot grid control

Asynchronous loading

Pivot grid performs long-running operations asynchronously on a background thread. This allows end users to access other UI controls without distraction.

Virtual scrolling support in WPF pivot grid control

Improved scrolling

Improved scrolling means a value only updates in the respective pivot grid view when the end user releases the scroll thumb.


Effective data binding

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.

Relational data source binding in WPF pivot grid control


Data exploration

Pivot grid control supports drill up and drill down to visualize the pivot information in both abstract and detailed views.


Pivot table field list and grouping bar

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.


Seamless editing experience

Editing

Pivot grid supports editing values at runtime, thereby updating the total cell simultaneously.

Editing value cell at run-time in WPF pivot grid control

Updating

Pivot grid supports updating values in real time by pushing the live data and refreshing the control whenever it’s required.

Updating value cell at run-time in WPF pivot grid control


Data shaping and manipulation

Filtering row and column headers in WPF pivot grid control

Filtering

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.

Sorting row and column header in WPF pivot grid control

Sorting

Pivot grid control has support to order rows and columns, either based on labels or values.

Calculations support in WPF pivot grid control

Calculations

Pivot grid supports inserting new calculations at runtime, along with 16 built-in calculation types.

Summaries support in WPF pivot grid control

Summaries

Pivot grid has extensive support for you to define your own custom summaries, along with 10 built-in summary types.


Drill through

Drill through easily obtains a list of raw items for a particular value cell or summary cell in pivot grid.

Drill through support in WPF pivot grid control


Visualizations

Normal

This looks like the pivot table in Excel, allowing the end user to pivot rows, columns, and calculations.

Normal view of WPF pivot grid control

Row pivots only

Users can customize the pivot grid to look like a flat grid. It allows users to pivot only rows and calculations.

Flat view of WPF pivot grid control

Summary layout

Summary layout easily switches the summary position either to the top or bottom beside each field of pivot grid.

Summary view of WPF pivot grid control


Persisting reports

Settings in the pivot grid control can be serialized to an XML format and loaded back through the built-in deserialization options.

Saving current report in WPF pivot grid control


Conditional formatting

Pivot grid allows users to define conditions that, when met, format values’ and summary cells’ font, color, and border settings.

Formatting cells at run time based on used-defined criteria in WPF pivot grid


Defer update

Users are allowed to refresh the pivot grid control only on demand and not during every UI interaction.


Interactive features

Freeze (aka, frozen) headers in WPF piot grid control

Freeze headers

There is built-in support for freezing row and column headers for better views of values in pivot grid.

Context menu support in WPF pivot grid control

Context menu

There is a UI option to expand/collapse a header to a certain extent.

Hyperlink support in WPF pivot grid control

Pivot grid retrieves information about a particular cell on hyperlink cell click. It later allows you to perform custom operations programmatically.

Selecting range of cells (aka, cell selection) in WPF pivot grid control

Selection

There is extensive support to select a range of value cells.

Show/hide totals in WPF pivot grid control

Hiding totals

Pivot grid has support to show/hide grand totals and subtotals for rows and columns.

Tooltip support in WPF pivot grid control

Tooltip

Tooltip provides basic information about a cell in pivot grid while hovering the mouse pointer over it.


Exporting and printing

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.

Printing and exporting to Excel, Word, PDF, and CSV in WPF pivot grid control


Rich look and feel

Built-in theme support in WPF pivot grid control

Built-in themes

Pivot grid ships with built-in themes like Blend, Office, Visual Studio, and Metro.

Custom XAML styling support in WPF pivot grid control

Custom Styling

Pivot grid provides ability to customize the appearance of the control to any extent programmatically.

Customize WPF pivot grid control appearance using theme studio

Theme studio

Easily customize all aspects of appearance using the theme studio utility.


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.