Automatic Summaries

Automatic summaries are calculated against data fields. You can specify the type of the summary function in code and control whether an end user can change the summary type.

API Description
PivotGridField.SummaryType Gets or sets the type of the summary function which is calculated against the current data field. This is a dependency property.
PivotGridField.AllowRuntimeSummaryChange Gets or sets whether an end user can change the data field's summary type. This is a dependency property.

For numeric data fields, the PivotGrid can calculate Sum, Min, Max, Average, Median, and other summary functions. For a complete list of the predefined summary functions and their descriptions, see the FieldSummaryType enumeration.

Data fields that contain non-numeric values can only use the Count, Min, and Max functions. Otherwise, the corresponding data cells display zeros.

See Also