[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Implementation Details
   [Expand]Views
   [Expand]Grid View Data Layout
   [Expand]Binding to Data
   [Expand]Master-Detail Data Representation
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Selection
   [Expand]Filtering and Searching
   [Expand]Sorting
   [Collapse]Data Summaries
     Data Summaries Overview
     Total Summary
     Group Summary
     Node Summary
     Custom Summary
     Runtime Summary Editor
   [Expand]Paging and Scrolling
   [Expand]Focus and Navigation
   [Expand]Conditional Formatting
   [Expand]Drag-and-Drop
   [Expand]Appearance Customization
   [Expand]MVVM Enhancements
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Miscellaneous
   [Expand]Performance Improvement
   [Expand]Design-Time Features
   [Expand]Visual Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Total Summary

Expanded Total Summary Overview

A total summary represents a value of an aggregate function calculated over all data rows displayed within a View. Total summaries are displayed within the Summary Panel or Fixed Summary Panel, provided that the DataViewBase.ShowTotalSummary and DataViewBase.ShowFixedTotalSummary options are enabled, respectively. Summaries displayed within the Fixed Summary Panel are not horizontally scrolled, they are always visible onscreen, regardless of the corresponding column's position and visibility.

Table Views and TreeList Views display Summary panels at the bottom.

In Card Views, the Summary Panel is displayed at the top, and the Fixed Summary Panel is displayed at the bottom.

Expanded Displaying Total Summaries

Total summaries are represented by the GridSummaryItem objects. The grid stores its total summaries within the GridControl.TotalSummary collection.

To create a total summary item at design time, use the TotalSummary Collection Editor.

By default, total summary items are displayed within the Summary Panel. To display a total summary item within the Fixed Summary Panel, align it to the Left or Right using the SummaryItemBase.Alignment property. If this property is set to 'Default', a summary item is displayed within the Summary Panel.

To create a total summary in code, create a new instance of the GridSummaryItem class, specify its SummaryItemBase.FieldName and SummaryItemBase.SummaryType properties and add it to the GridControl.TotalSummary collection. To display a summary item within the Fixed Summary Panel, align it to the Left or Right using the SummaryItemBase.Alignment property.

End-users can display total summaries via the Summary Panel's popup menu. You can enable or disable the total summary popup menu using the DataViewBase.IsTotalSummaryMenuEnabled property. To learn more, see Customizing Summaries and Runtime Summary Editor.

Note

In Master-Detail mode, total summary rows are only visible when you scroll to the bottom of the detail. You cannot make them always visible regardless of the vertical scrolling position. To learn more, see Master-Detail Mode Limitations.

Expanded Obtaining Summary Values

To obtain a total summary value, use the DataControlBase.GetTotalSummaryValue method. To obtain a list of total summary items displayed within a column, use the column's ColumnBase.TotalSummaries property.

To determine whether a column displays a total summary(s), use the ColumnBase.HasTotalSummaries property.

Use the DataViewBase.FixedSummariesLeft and DataViewBase.FixedSummariesRight properties to obtain total summaries displayed within the Fixed Summary Panel and aligned to the Left or Right, respectively.

Expanded Server Mode Limitations

In a Server Mode, total summaries cannot be calculated for Unbound Columns whose values are calculated via events. Only columns with the specified unbound expressions support total summaries.

Expanded See Also

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