Skip to main content
BuyLog In
Silverlight Controls
Search in…
Docs > Silverlight Controls > Controls > Pivot Grid > Product Information > Main Features
All docs
V14.2
Silverlight Controls
What Is New
Installation and Demos
Common Concepts
Controls
Reporting
Data Grid
Ribbon Controls
Toolbar-Menu
Chart Control
Pivot Grid
Product Information
Main Features
Included Components
Deployment
Getting Started
Fundamentals
Concepts
Visual Elements
End-User Capabilities
Examples
Scheduler
Rich Text Editor
Tree List
Gauge Controls
Map Control
Dock Windows
Tile and Layout
Printing-Exporting
Data Editors
Navigation Bar
Utility Controls
Spell Checker
LightSwitch Reporting
Localization
Redistribution and Deployment
Get More Help
API Reference

Main Features

  • 3 minutes to read

As a comprehensive feature-rich control designed specifically for Silverlight, Pivot Grid gives you the maximum capabilities for organizing, summarizing and analyzing your business data.

Below is a list of the main DXPivotGrid features.

  • Support for Multiple Datasource 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 PivotGridControl.
  • 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 - values of column and row fields are listed along the top and right edge of the control, and 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 (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.
  • Grouping Values into Intervals - values of column and row fields can be grouped into intervals. In this instance, multiple field values that 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). For fields that display date/time data, values can be grouped by years, quarterly intervals, months, etc.
  • Multiple Fields can be bound to the same data source field, and group field values into different intervals.
  • Filtering Data - this feature enables you to limit which records are processed by DXPivotGrid. An end-user can easily change a filter at runtime via a filter drop-down or a Filter Control.
  • 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 the field sort order (from ascending to descending and vice versa) by clicking the field header.
  • Sorting by Summary Values - DXPivotGrid enables column and row field values to be sorted by total summary values.
  • The Top N Values Feature - along with the Sorting By Summary feature, the pivot grid allows you to display the specified number of topmost values thus showing the most important information and ignoring the rest.
  • 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; for example DXGrid - this makes your application's look and feel consistent.
  • 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.
  • Interface Elements Localization.