Grouping And Aggregates Sample 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