Totals

ShipCountry
ProductName
UnitPrice
Quantity
Discount
Discontinued
OrderDate
Germany
Chai
14.40
45
0.20
9/20/1994
USA
Chai
14.40
18
0.00
9/30/1994
USA
Chai
14.40
20
0.00
10/31/1994
Germany
Chai
14.40
15
0.15
12/8/1994
Mexico
Chai
14.40
12
0.00
12/15/1994
Switzerland
Chai
14.40
15
0.15
1/3/1995
Brazil
Chai
14.40
10
0.00
2/7/1995
France
Chai
14.40
24
0.00
2/14/1995
Portugal
Chai
14.40
15
0.00
4/17/1995
Germany
Chai
18.00
40
0.20
5/31/1995
Finland
Chai
18.00
8
0.15
6/5/1995
Mexico
Chai
18.00
10
0.00
7/24/1995
Canada
Chai
18.00
20
0.00
8/7/1995
France
Chai
18.00
3
0.00
8/24/1995
Poland
Chai
18.00
6
0.00
8/25/1995
Count: 15
 
Avg: 15.84
Sum: 261
Max: 0.20
 
 

This sample shows how to use the Aggregate, ShowFooter, and FooterText properties to calculate totals for specific columns.