CrossTabDataField.SummaryType Property
Specifies the summary function to calculate against a field.
Namespace: DevExpress.XtraReports.UI.CrossTab
Assembly: DevExpress.XtraReports.v24.2.dll
NuGet Package: DevExpress.Reporting.Core
#Declaration
[DefaultValue(SummaryType.Sum)]
[SRCategory(ReportStringId.CatData)]
public SummaryType SummaryType { get; set; }
#Property Value
Type | Default | Description |
---|---|---|
Summary |
Sum | The summary function. |
Available values:
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. |
Std |
The standard deviation of all the values. |
Std |
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. |
Count |
The number of unique values. |
Median | The middle value in an ordered list of values. |
Mode | The value that appears most frequently. |
#Remarks
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.
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).