Example of Default Aggregate in Javascript Data Grid Control

/
/
Default Aggregate

This sample demonstrates the aggregate functionality of the Grid. In this sample, the aggregate values for the columns are displayed in the column footer.

More Details...

Description

The Grid supports displaying aggregates in its footer, group footer and group caption. The aggregate configurations can be provided by the aggregates property. Built-in aggregates: Sum Average Min Max Count TrueCount FalseCount Custom - Requires the customAggregate property to perform aggregation. The custom aggregate value can be accessed inside template using the key ${custom}. In this demo, the footerTemplate property is used to display four different aggregates (${Sum}, ${Average}, ${Max} and ${Min}) in the Grid footer. Each aggregate type is specified using the type and field properties accessed in the footerTemplate with its type name. The aggregate value will be formatted based on its format value (N2 or C2) before being displayed. The template expression should be provided inside ${...} the interpolation syntax. More information on the stacked header configuration can be found in this documentation section.