Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Built-in Functions

 DepartmentLocationBudget
CollapseCorporate HeadquartersMonterey$1,000,000.00
 CollapseSales and MarketingSan Francisco$22,000.00
   Field Office: CanadaToronto$500,000.00
   Field Office: East CoastBoston$500,000.00
  ExpandPacific Rim HeadquartersKuaui$600,000.00
   MarketingSan Francisco$1,500,000.00
   Count=6 Max=$1,500,000.00
Sum=$3,900,000.00
  FinanceMonterey$40,000.00
 CollapseEngineeringMonterey$1,100,000.00
  ExpandConsumer Electronics Div.Burlington, VT$1,150,000.00
  ExpandSoftware Products Div.Monterey$1,200,000.00
   Count=7 Max=$1,200,000.00
Sum=$3,786,000.00
  Count=16 Max=$1,500,000.00
Sum=$8,848,000.00
 Count=17 Max=$1,500,000.00
Sum=$9,848,000.00

The DevExpress ASP.NET Tree List (ASPxTreeList) enables you to calculate summary values for all values within a column or a group of nodes, and display the results within footer cells. The ASPxTreeList provides five built-in aggregate functions (average, count, max, min and sum).

Summaries can be displayed within Footer or Group Footer cells. The ASPxTreeList allows multiple summaries to be displayed within individual footer or group footer cells.

For example, in this demo, two summaries are displayed within the footer cells of the Budget column. The first summary displays the highest amount of the Budget value for a particular group. The second summary displays the sum of all Budget values within a particular group.

The Footer is displayed if the Settings.ShowFooter property is set to true. Group Footers are displayed if the Settings.ShowGroupFooter option is enabled.

The ASPxTreeList stores its summary items in the Summary collection.