Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Grid Totals

Company Name 
City 
Region 
Country 
Unit Price 
Quantity 
Total 
Blondesddsl père et filsStrasbourg France$31.2030$936.00
Blondesddsl père et filsStrasbourg France$12.0020$240.00
Morgenstern GesundkostLeipzig Germany$36.4020$728.00
Morgenstern GesundkostLeipzig Germany$39.4012$472.80
Berglunds snabbköpLuleå Sweden$3.6012$43.20
Berglunds snabbköpLuleå Sweden$19.2020$384.00
Berglunds snabbköpLuleå Sweden$6.2030$186.00
Vins et alcools ChevalierReims France$30.404$121.60
Magazzini Alimentari RiunitiBergamo Italy$13.6030$408.00
Magazzini Alimentari RiunitiBergamo Italy$10.0020$200.00
Count=2,155    Min=1
Avg=23.81
Max=130
Sum=$1,354,458.59
Page 1 of 216 (2155 items)Prev1234567214215216Next

The DevExpress ASP.NET Grid View (ASPxGridView) is a powerful data shaping control that includes a variety of data summary calculation options. Total summaries are aggregate function values calculated against all rows in the ASPxGridView, and displayed in the grid footer, provided that the Settings.ShowFooter option is enabled.

The ASPxGridView stores its total summary items, which are instances of the ASPxSummaryItem class, in the TotalSummary collection.

The built-in aggregate functions include: Min, Max, Avg, Sum and Count.

In this demo, the Total grid column is declared as unbound by setting the UnboundType property to Decimal. The column's cell values are calculated at runtime in the CustomUnboundColumnData event handler.


See Also:
Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxGridViewDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxGridViewDemos