[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Collapse]Data Shaping
       Summaries Overview
       Automatic Summaries
       Custom Summaries
      [Expand]Summary Display Modes
       Accessing Cell Values
       Drill Down to the Underlying Data
      Aggregation Levels
     Data Formatting
   [Expand]Data Analysis
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Summaries Overview

Cells in the PivotGridControl display the results of summaries calculated against data fields. Pivot Grid Control supports both automatic and Custom Summaries. Automatic Summaries are always calculated against data fields, while Custom Summaries can be calculated against any field (including the data fields) or multiple fields at the same time.

Summaries are calculated for a subset of records from the control's underlying data source. All the records in this subset have matching values in a Column Field(s) and Row Field(s) and these values are identified by column and row headers.

Summary values are displayed within cells in the Data Area. The following Pivot Grid Control contains two data fields - Product Sales and Quantity.

The summary value in the left-topmost cell ($38,487.20) has been calculated against the Product Sales field for a subset of records that have the:

  • value 'Beverages' in the Category Name field
  • value 1994 in the Year field

The summary value in the bottommost cell in the second column (100) has been calculated against the Quantity field for a subset of records that have the:

  • value 1994 in the Year field

Use the PivotGridFieldBase.SummaryType property to specify the type of the summary function which is calculated against a data field. You can enable the data field's summary change menu to allow end users to change the summary type at runtime. Use the PivotGridFieldOptions.AllowRunTimeSummaryChange property to enable this menu.

For information on how to obtain summary values, see Accessing Cell Values.

To learn how to display correlations between different summary values, instead of displaying raw summaries, see Summary Display Modes.

Expanded See Also

Is this topic helpful?​​​​​​​