Aggregates

21 Dec 20221 minute to read

Aggregate values are displayed in the footer, group footer, or group caption of the Grid. It can be configured through Aggregates property. The Field and Type are the minimum properties required to represent an aggregate column.

By default, the aggregate value can be displayed in the footer, group, and caption cells. To show the aggregate value in one of the cells, use the FooterTemplate, GroupFooterTemplate, or GroupCaptionTemplate property.

Built-in aggregate types

The aggregate type should be specified in the Type property to configure an aggregate column.

The built-in aggregates are,

• Sum
• Average
• Min
• Max
• Count
• TrueCount
• FalseCount

NOTE

Multiple aggregates can be used for an aggregate column by setting the Type property with an array of aggregate types.

Multiple types for a column is supported only when one of the aggregate templates is used.