A comprehensive feature-rich control designed specifically for the .NET Framework the XtraPivotGrid gives you the maximum capabilities for organizing, summarizing and analyzing your business data.

Below is a list of the main features of the XtraPivotGrid control. 
•	Support for multiple data source types - full support for ADO+ and custom data sources that implement the IList interface. 
•	MS Analysis Services Support - You can use MS Analysis Services (OLAP) as a data source for the PivotGridControl. Specify the connection settings to the server via the PivotGridControl.OLAPConnectionString property.
ü	Automatic summary calculation for each cell - There are 9 summary functions available: Sum, Count, Min, Max, Average, Standard Deviation based upon a sample, Standard Deviation based upon the entire population, Variation based upon a sample and Variation based upon the entire population. 
ü	Any number of data fields - This feature allows you to calculate and display multiple summaries at the intersection of each column and row. 
ü	Any number of column and row fields - The values of column and row fields are listed along the top and right edge of the control and they identify the column and row headers. The values of multiple column(row) fields are arranged into a hierarchy and can be expanded.. 
ü	Automatic Total calculation - Totals (which are inserted as additional rows or columns) display total summaries calculated for outer column and row fields. 
ü	Automatic Grand Total calculation - Grand Totals display overall summary totals calculated against all the columns and rows. They are displayed as the bottommost rows or rightmost columns. 
ü	Multiple Totals - It's possible to calculate multiple Totals for specific column and row fields. 
ü	Grouping values into intervals - The values of column and row fields can be grouped into intervals. In this case multiple field values which have a specific matching value part will be congregated into a single item. For text fields you can group values alphabetically (by the first character the values start with). For fields that display date/time data the values can be grouped by years, quarterly intervals, months, etc. 
ü	Multiple fields can be bound to the same data source field and they group field values into different intervals. 
ü	Filtering data - This feature enables you to limit which records are processed by the XtraPivotGrid control. An end-user can easily change the filter at runtime via the Filter Dropdown. 
ü	Automatic sorting of column and row field values in alphabetical order (for text data) and in order of magnitude (for numeric and date/time data). An end-user can change a field's sort order (from ascending to descending and vice versa) by clicking the field header. 
ü	Sorting by summary values - The XtraPivotGrid control enables column and row field values to be sorted by total summary values. 
ü	The Top X Values feature - Along with the Sorting By Summary feature it allows you to display the specified number of topmost values thus showing the most important information and ignoring the rest. 
ü	Unbound fields - Bound fields get their data from the control's underlying data source, while unbound fields should be populated manually via an event. So arbitrary data can be displayed and analyzed in the XtraPivotGrid control. 
ü	Linking fields - Fields can be combined into groups. Such fields cannot be separated and are treated as a group, so when an end user drags one of the fields all the linked fields are dragged as well.
ü	Customizable position of data field headers.
ü	Accessing records used to calculate summaries in particular cells - With a few lines of code you can display and browse these records in your favorite Grid control. Using the XtraGrid control to do this makes your application's look and feel consistent, as the XtraPivotGrid and XtraGrid controls share the same Painting library. 
ü	Formatting the display text within data cells, columns and row headers. 
ü	Providing the display text for data cells and column and row headers via events. The customized display text will be used when the XtraPivotGrid control is printed or exported. 
ü	Images in field headers and field value headers. 
ü	Customizable appearances for each element. 
ü	Style conditions give you a simple and flexible method of specifying different styles for cells depending upon cell data. 
ü	Custom drawing - Each element can be painted manually. 
ü	Multiple paint styles support - The control gives you five look and feels including Windows XP and Office 2003 style. Additionally, it can be painted in one of the 8 built-in skins and you can create custom skins. 
ü	Print support - the contents of the XtraPivotGrid control can be printed out via the XtraPrinting library. 
ü	Export to HTML, MHT, RTF, XML, TXT, XLS and PDF formats (via the XtraPrinting library). 
ü	Save and load the control's layout - The layout can be saved to and restored from the system registry, an XML file or a stream. 
ü	Localization of interface elements. 
ü	Cell selection and copying to clipboard - An end-user can select a range of cells with the mouse and then copy their contents by pressing the CTRL+C shortcut. The selected data is copied to the clipboard in the tab-separated format that is natively supported by Microsoft Excel, for instance. 
ü	Dragging fields between different areas - End-users can freely drag field headers between different control areas. This gives them full control when analyzing the data. 
ü	Built-in Customization Form allows end-users to temporarily hide fields and make them visible again. 
ü	Built-in context menus provides access to the most commonly used features. 
ü	Advanced Designer - This provides tools to manage fields, customize the display and print appearance settings, save and load the control's layout, etc. 
ü	On-form access to individual fields at design time. You can click a field header to display the corresponding field's properties and events within the Properties window.