PlatinumGrid
develop faster.
Summary
Page 1 of 2. (32 rows)
<<<12>>>
» CustomerID
 
SalesOrderID
SubTotal
Total
CustomerID: 6  (SalesOrderID Count: 2) (Total Avg: $1,203.42 Sum: $2,406.84)
26 
26
$40.90
$45.20
25 
25
$2,137.23
$2,361.64
CustomerID: 187  (SalesOrderID Count: 6) (Total Avg: $11,581.38 Sum: $69,488.27)
17 
17
$3,324.28
$3,673.32
14 
14
$2,453.76
$2,711.41
15 
15
$602.19
$665.43
16 
16
$13,823.71
$15,275.20
18 
18
$1,059.31
$1,170.54
13 
13
$41,622.05
$45,992.37
CustomerID: 223  (SalesOrderID Count: 4) (Total Avg: $42,305.30 Sum: $169,221.20)
21 
21
$12,685.89
$14,017.91
22 
22
$63,980.99
$70,698.99
23 
23
$2,415.67
$2,669.32
24 
24
$74,058.81
$81,834.98
CustomerID: 268  (SalesOrderID Count: 2) (Total Avg: $440.42 Sum: $880.83)
19 
19
$550.39
$608.18
20 
20
$246.74
$272.65
CustomerID: 420  (SalesOrderID Count: 6) (Total Avg: $32,780.86 Sum: $196,685.16)
12 
12
$35,775.21
$39,531.61
10 
10
$3,398.17
$3,754.97
9 
9
$1,141.58
$1,261.44
8 
8
$78,029.69
$86,222.81
7 
7
$57,634.63
$63,686.27
11 
11
$2,016.34
$2,228.06
 
Count:  32
Avg:  $27,044.78
Sum:  $865,433.11
Sum:  $956,303.60
Page 1 of 2. (32 rows)
<<<12>>>

PlatinumGrid supports the calculation and display of column summaries at both the group and grid levels. Supported aggregate functions are: Average, Count, Maximum, Minimum and Sum.

In addition, the calculated value can optionally be formatted using an event handler. This demo uses that event handler to format some of the summaries in currency format.