When it comes to data mining and multi-dimensional analysis, an advanced and feature complete pivot table control provides business users unrivaled insights into daily operations. Until the release of the XtraPivotGrid for .NET, however, using the pivot capabilities of products like MS Excel® meant introducing "out-of-process" solutions within managed applications.

The XtraPivotGrid Suite was engineered from the ground-up to blow away the limitations posed not just by these out-of-process solutions, but to radically improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, the XtraPivotGrid is able to slice and dice information efficiently and provide customers with an extremely intuitive end-user experience. It delivers numerous layout customization options with total end-user control over each individual on-screen report. Regardless of the perspective, data can be rendered to answer business questions - and best of all - it allows you to focus on business rules rather than creating dozens and dozens of reports.

	Quickly Display Table Data into Fully Customizable Slice-and-Dice Reports Our Pivot Grid Control has the power to convert hard to read and difficult to dissect dataset information into compact and summarized visual reports, thus addressing your customer's real-time business analysis needs. And just as important, users can easily change a report's layout visually in order to examine data from different/multiple perspectives so you never again have to foresee all possible report scenarios your end-users may require.
	OLAP Data Source Support Microsoft Analysis Services (OLAP) data sources are now fully supported by our hypercube control. If bound to such a data source, a pivot grid delegates all data management and calculations to the server side.
	Asynchronous Data Processing Mode You no longer have to wait for your application to unfreeze while the pivot grid is processing data. When an asynchronous data processing mode is enabled, the entire application stays responsive while the pivot grid is busy with calculations.
	Print and Export Data - Instant Cross-tab Reports in PDF, XLS, HTML Formats and on Paper XtraPivotGrid is NOT just about on-screen data analysis. With it, you can export data to numerous formats and render its contents to paper just like a traditional WYSIWYG report.
	Data Visualization via Charting Control Integration The DevExpress pivot grid allows the data it displays to be visualized using our .NET Charting Control. This is possible because the PivotGrid can act as a data source for other controls.
	Provide Different Levels of Detail for Flexible Data Analysis End-users may not want to browse through each and every unique respondent age value and instead want to see the ages of respondents in intervals such as 21-30, 31-40, etc. Instead of viewing sales by each unique date, they may want to view the sales against months.
	Hierarchical Data Display - Raw and Summarized Data in a Single Report Field values are automatically arranged into a tree structure with expandable parents. End-users are free to expand and collapse child groups to see more summarized or raw reports.
	Automatic and Manually Calculated Totals Among the many features available in the component library is its ability to display grand totals for each row and column automatically. On the rare occasion that the built-in summary computation engine does not address a specific business requirement, you can display any number of totals for any value group.
	Sort Data and Display Top or Bottom Numbers - Easily Access the Most Important Information Comprehensive data analysis often requires a two-way approach to data navigation - you may need to find data by a specific value or find a value by its data. This means that sometimes you need the first product to be the one with the most or least sales, rather than the one which starts with an A or a Z.
	End-User Data Filtering With the Pivot Grid's built-in visual filtering option, your end-users can manipulate reports on the fly using an easy to understand and familiar visual metaphor.
	In-place Editing and Data Validation The Pivot Table Control allows end-users to perform 'what-if' analysis by editing summary values displayed in data cells.
	Drill Down - Take a Look at the Data Behind a Summary With just a single line of code, you can take a look at the records that were used to calculate cell values. With a few more lines of code, you can display this data within a standard DataGrid control, our advanced WinForms Grid control or any other control designed for displaying table data.
	Unbound Columns and Expression Editor You can now create unbound fields and populate them with data as your needs dictate.