Page 1 of 6 (118 items)
Prev
[1]
2
3
4
5
6
Next
Quantity
Extended Price
Year
Category Name
Product Name
1995
QuantityExtended Price
BeveragesChai319$900.00
Chang375$950.00
Chartreuse verte155$360.00
Côte de Blaye248$10,540.00
Guaraná Fantástica411$273.60
Ipoh Coffee228$2,760.00
Lakkalikööri482$1,440.00
Laughing Lumberjack Lager62$420.00
Outback Lager438$750.00
Rhönbräu Klosterbier513$387.50
Sasquatch Ale171$560.00
Steeleye Stout401$691.20
Beverages Average22.77$613.65
Beverages Count167167
Beverages Max80$10,540.00
Beverages Min2$13.50
Beverages Sum3803$102,479.44
CondimentsAniseed Syrup170$600.00
Chef Anton's Cajun Seasoning264$1,045.00
Chef Anton's Gumbo Mix51$544.00
Grand Total25007$10,540.00
Page 1 of 6 (118 items)
Prev
[1]
2
3
4
5
6
Next
Description
C#
VB
ASPX

For each field, you can manually specify the number and type of group totals to be displayed. This demo shows how to display the Average, Sum, Maximum and Minimum summaries for each Category group.

The CustomTotals collection contains PivotGridCustomTotal objects that represent custom totals for the field. These custom totals are displayed when the field is located within the Column Header Area or Row Header Area and only if its TotalsVisibility property is set to DevExpress.XtraPivotGrid.PivotTotalsVisibility.CustomTotals.