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.
|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.