Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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