Page 1 of 2 (17 items)
Prev
[1]
2
Next
Country
City
Quantity
Discount
Drop Column Fields Here
Category Name
Products
Grand Total
QuantityDiscount
BeveragesChang1057.004.50
Guaraná Fantástica1125.002.90
Outback Lager817.002.45
Sasquatch Ale506.000.95
Beverages Average876.252.70
Beverages Count44
Beverages Max1125.004.50
Beverages Min506.000.95
Beverages Sum3505.0010.80
Condiments1273.003.30
Grand Total19944.0047.13
Page 1 of 2 (17 items)
Prev
[1]
2
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.