Log In
[Expand]General Information
[Collapse]WinForms Controls
 [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
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Expand]Grid View
   [Expand]View Technology
     Summaries Overview
     Tutorial: Custom Summary Functions
     Tutorial: Format Summary Text
     Tutorial: Group Summaries
     Tutorial: Obtain Summary Values
     Tutorial: Sort Group Rows by Summary Values
     Tutorial: Total Summaries
     Total Summary
     Group Summary
     Custom Aggregate Functions
     Format Summary Values
     Obtain Summary Values
     Sorting Group Rows by Summary Values
     Controlling Visibility of Group Summaries for Individual Group Rows
   [Expand]Data Editing
   [Expand]Filtering and Locating Rows
   [Expand]Focus and Selection Handling
   [Expand]Processing Rows
   [Expand]Formatting Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
   [Expand]Batch Modifications
   [Expand]Hit Information
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]End-User Capabilities
    Included Components
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [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]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Total Summary

This topic provides information about total summaries. Basic summary information is presented in the Summaries Overview topic.

Expanded Online Video

Learn how end-users can add or remove total summaries using built-in footer menus, how to prevent them from customizing the totals you have specified, and how to pre-define the grid totals at design-time or in code.

Expanded Total Summary

Total summaries can only be displayed in a Grid View and its descendants within footer cells. To display the footer, set the GridOptionsView.ShowFooter option to true. The total summary for a column represents a value of an aggregate function calculated over all rows.

The Grid allows you to display a single total summary or add multiple total summaries for a column. Use the GridColumn.SummaryItem property to show a single total summary, or the GridColumn.Summary property to show multiple total summaries.

If the GridOptionsBehavior.AutoUpdateTotalSummary option is set, total summaries are recalculated each time when you change a column value. When a View displays a large amount of data or you perform batch modifications, automatic summary updates may slow down your application. In such cases, it is better to turn it off and use the GridView.UpdateTotalSummary method to force recalculation after all changes have been made. The GridView.UpdateSummary method can be used to update total and group summaries.

Expanded Showing a Single Summary

The GridColumn.SummaryItem property is a GridSummaryItem object, which allows you to set the field against the values the summary has calculated, the aggregate function applied to field values and the summary value format. The image below shows how to customize the column summary type and display format via the GridSummaryItem.SummaryType and GridSummaryItem.DisplayFormat properties respectively.

Expanded Example

The example demonstrates how to calculate a single total summary for a grid column via the GridColumn.SummaryItem property.

Expanded Adding Multiple Summaries

The GridColumn.Summary property is a collection of GridSummaryItemCollection objects. The image below shows how to use this property to add multiple total summaries to the collection.

Expanded Example

This example demonstrates how to add multiple total summaries for a column at runtime.

Expanded See Also

How would you rate this topic?​​​​​​​