GridView - Grouping - Grouping And Aggregates

Grouping And Aggregates

Name	OrderID	Quantity	Totals
Name: Chai 5		110	1,584.00
Chai	10,317	20	288.00
Chai	10,285	45	648.00
Chai	10,294	18	259.20
Chai	10,348	15	216.00
Chai	10,354	12	172.80
Name: Chang 7		201	3,055.20
Chang	10,264	35	532.00
Chang	10,298	40	608.00
Chang	10,258	50	760.00
Chang	10,255	20	304.00
Chang	10,327	25	380.00
Chang	10,335	7	106.40
Chang	10,342	24	364.80
Name: Aniseed Syrup 1		30	240.00
Aniseed Syrup	10,289	30	240.00
Name: Chef Anton's Cajun Seasoning 5		107	1,883.20
Chef Anton's Cajun Seasoning	10,336	18	316.80
Chef Anton's Cajun Seasoning	10,344	35	616.00
Chef Anton's Cajun Seasoning	10,309	20	352.00
Chef Anton's Cajun Seasoning	10,339	10	176.00
Chef Anton's Cajun Seasoning	10,326	24	422.40
Name: Chef Anton's Gumbo Mix 3		97	1,649.00
Chef Anton's Gumbo Mix	10,258	65	1,105.00
Chef Anton's Gumbo Mix	10,262	12	204.00
Chef Anton's Gumbo Mix	10,290	20	340.00
Name: Grandma's Boysenberry Spread 2		36	720.00
Grandma's Boysenberry Spread	10,325	6	120.00
Grandma's Boysenberry Spread	10,309	30	600.00
Name: Uncle Bob's Organic Dried Pears 1		15	360.00
Uncle Bob's Organic Dried Pears	10,262	15	360.00
Name: Northwoods Cranberry Sauce 2		140	4,480.00
Northwoods Cranberry Sauce	10,344	70	2,240.00
Northwoods Cranberry Sauce	10,345	70	2,240.00
Name: Ikura 3		69	1,711.20
Ikura	10,273	24	595.20
Ikura	10,276	15	372.00
Ikura	10,357	30	744.00
Name: Queso Cabrales 5		110	1,814.40
Queso Cabrales	10,296	12	201.60
Queso Cabrales	10,248	12	168.00
Queso Cabrales	10,365	24	403.20
Queso Cabrales	10,327	50	840.00
Queso Cabrales	10,353	12	201.60
Name: Queso Manchego La Pastora 1		12	364.80
Queso Manchego La Pastora	10,266	12	364.80
Name: Konbu 3		42	201.60
Konbu	10,291	20	96.00
Konbu	10,276	10	48.00
Konbu	10,325	12	57.60
Name: Tofu 3		28	520.80
Tofu	10,249	9	167.40
Tofu	10,333	10	186.00
Tofu	10,325	9	167.40
Name: Genen Shouyu 2		25	310.00
Genen Shouyu	10,323	5	62.00
Genen Shouyu	10,283	20	248.00
Name: Pavlova 7		252	3,502.80
Pavlova	10,263	60	834.00
Pavlova	10,296	30	417.00
Pavlova	10,324	21	291.90
Pavlova	10,310	10	139.00
Pavlova	10,287	40	556.00
Pavlova	10,359	56	778.40
Pavlova	10,255	35	486.50

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.