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.

Overview

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.

Overview


DataBinding

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.


Pivot table field list and grouping bar

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.


Data shaping and manipulation

Filtering

Filtering

A built-in filter UI allows you to easily filter and view data. It is also possible to filter programmatically.

Sorting

Sorting

Order rows and columns based on headers.


Data exploration

There is built-in support to drill up and drill down to visualize the grid information in both abstract and detailed views.


Calculations

Calculations

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.


Summaries

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.

Summaries


Editing and updating

Editing

Edit the values at runtime, thereby updating the total cell simultaneously.

Editing

Updating

Update values in real time by pushing the live data and refreshing the control whenever required.

Updating


AsynchronousLoading

Asynchronous data processing

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


Layouts

Normal layout

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

Normal

Flat layout

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

FlatLayout

Hiding totals

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

HidingTotals


PersistingReports

Persisting reports

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


Conditional formatting

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


Interactive features

FreezeHeaders

Freeze headers

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

Selection

Selection

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

Tooltip

Tooltips

Tooltips provide basic information about a cell while hovering the mouse pointer over it.

Hyperlink

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

DeferUpdate

Defer update

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


Exporting and printing

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.

ExportingPrinting


Localization

Localization

Every static text in the pivot grid and built-in dialogs can be localized to any desired language.


Right to left

Pivot grid can render headers and values from right to left to adhere to certain local standards.

RTL


Rich look and feel

Built_Themes

Built-in themes

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

Custom_Styling

Custom styling

Customize the appearance of the control to any extent programmatically.


No results found

GRID

DATA VISUALIZATION

DATA SCIENCE

EDITORS

NAVIGATION

FILE FORMAT LIBRARY

NOTIFICATION

LAYOUT

MISCELLANEOUS

BUSINESS INTELLIGENCE

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.