xtrareports-devexpress-dot-xtrareports-dot-ui-dot-crosstab-dot-crosstabdatafield.md
Specifies the summary function to calculate against a field.
Namespace : DevExpress.XtraReports.UI.CrossTab
Assembly : DevExpress.XtraReports.v25.2.dll
NuGet Package : DevExpress.Reporting.Core
[DefaultValue(SummaryType.Sum)]
[SRCategory(ReportStringId.CatData)]
public SummaryType SummaryType { get; set; }
<DefaultValue(SummaryType.Sum)>
<SRCategory(ReportStringId.CatData)>
Public Property SummaryType As SummaryType
| Type | Default | Description |
|---|---|---|
| SummaryType | Sum |
The summary function.
|
Available values:
Show 12 items
| Name | Description |
|---|---|
| Count |
The number of values.
| | Sum |
The sum of all the values.
| | Min |
The smallest value.
| | Max |
The largest value.
| | Average |
The average of all the values.
| | StdDev |
The standard deviation of all the values.
| | StdDevp |
The standard population deviation of all the values.
| | Var |
The amount of variance for all the values.
| | Varp |
The population variance for all the values.
| | CountDistinct |
The number of unique values.
| | Median |
The middle value in an ordered list of values.
| | Mode |
The value that appears most frequently.
|
The Cross Tab summarizes values of data fields and displays the results at the intersection of the corresponding row and column.
Use the SummaryType property to change the type of the summary function. To access this property at design time, select a cell bound to the corresponding data field and click its smart tag. Alternatively, you can set this property in the Properties window.
The cell’s TextFormatString property allows you to format data accordingly.
SummaryType = Sum
SummaryType = Average
SummaryType = Count
Note
If a data field contains non-numeric values, you can only calculate the Count , Min and Max functions. Otherwise, zeros are displayed in the Cross Tab cells.
Use the SummaryDisplayType property to display results not “as is”, but in correlation with other cells (for instance, the percentage of grand total values).
See Also