Example of Default Aggregate in React Tree Grid Component

All Controls
/
Treegrid
/
AggregateRow

This sample demonstrates aggregate functionality of the Tree Grid. In this sample, the aggregate value for the columns “Total Units” and “Unit Weight” is displayed in column footer and provide an option to show child summary.

More Details...

CX2389NK
Maersk Edibles Co.59241
QW4567OP
Chang1250
QW3458BH
Aniseed Syrup8987
QW8967OH
Chef Anton4654
QW6549NJ
Chef Antons Gumbo Mix3450
Minimum: 12Maximum: 87
DW8954IO
Aeon fitness inc.172296
UF5647YH
Reebox CrossFit Back Bay6073
UF1290LK
The Green Microgym5690
UF8956KU
DeFrancos4568
UF7464JK
Westside Barbell2565
Minimum: 25Maximum: 90
EJ9456KN
Sun technologies inc33192
GH2367OP
Haier Group7823
GH4309TH
Panda Electronics9048
GH3494SD
Jiangsu Etern3656
GH3213FR
Zhejiang Fuchunjiang1265
Minimum: 12Maximum: 65
Properties
Show Child Summary
Description

The Tree Grid supports aggregates which will be displayed at the footer and every hierarchy level. The aggregate configurations can be provided by the aggregates property.

The built-in aggregates are,

  • 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 three different aggregates in the Tree Grid footer.

  • Showing minimum aggregate for “Total Units” column and the footerTemplate using its type name as (${'Min'}).
  • Showing average aggregate for “Unit weight column” column and the footerTemplate using its type name as (${'Max'}).

The template expression should be provided inside ${'...'} the interpolation syntax.

Additionally, the Tree Grid supports client-side exporting to Excel, PDF, and CSV formats. In this demo, for the toolbar items of exporting, actions are defined in the toolbarClick event to export the Tree Grid data using the excelExport, pdfExport, and csvExport methods.

Injecting Module:

Tree Grid features are segregated into individual feature-wise modules. To use aggregate feature, we need to inject Aggregate module into the services.

More information about aggregate can be found in this documentation section.