Grouping And Aggregates

NameOrderIDQuantityTotals
Chai1031720288
Chai1028545648
Chai1029418259.2
Chai1034815216
Chai1035412172.8
Chang1026435532
Chang1029840608
Chang1025850760
Chang1025520304
Chang1032725380
Chang103357106.4
Chang1034224364.8
Aniseed Syrup1028930240
Chef Anton's Cajun Seasoning1033618316.8
Chef Anton's Cajun Seasoning1034435616
Chef Anton's Cajun Seasoning1030920352
Chef Anton's Cajun Seasoning1033910176
Chef Anton's Cajun Seasoning1032624422.4
Chef Anton's Gumbo Mix10258651105
Chef Anton's Gumbo Mix1026212204
Chef Anton's Gumbo Mix1029020340
Grandma's Boysenberry Spread103256120
Grandma's Boysenberry Spread1030930600
Uncle Bob's Organic Dried Pears1026215360
Northwoods Cranberry Sauce10344702240
Northwoods Cranberry Sauce10345702240
Ikura1027324595.2
Ikura1027615372
Ikura1035730744
Queso Cabrales1029612201.6
Queso Cabrales1024812168
Queso Cabrales1036524403.2
Queso Cabrales1032750840
Queso Cabrales1035312201.6
Queso Manchego La Pastora1026612364.8
Konbu102912096
Konbu102761048
Konbu103251257.6
Tofu102499167.4
Tofu1033310186
Tofu103259167.4
Genen Shouyu10323562
Genen Shouyu1028320248
Pavlova1026360834
Pavlova1029630417
Pavlova1032421291.9
Pavlova1031010139
Pavlova1028740556
Pavlova1035956778.4
Pavlova1025535486.5
Description

The C1GridView supports aggregates calculation against one or more grouped columns (see: GroupArea sample).

It is possible to calculate aggregate values for each group of data rows. An aggregate can be calculate for any column with compatible data type if the column is preceded by a grouped column. C1GridView supports aggregate functions like Sum, Count, Min, Max and other.

The following column properties are used in this sample:

  • GroupInfo.Position - to group the ProductID column.
  • Aggregate - to specify aggregates for the ProductName, Quantity and Total columns.
Documentation