Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Data Summary via Built-in Functions

 
Department
Location
Budget
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 TreeList enables you to calculate summary values for all values within a column or within a group of nodes, and display the result inside footer cells. The TreeList provides five built-in aggregate functions (count, max, min, etc.).

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

For instance, in this demo, two summaries are displayed within the Budget column's footer cells. The first summary displays the maximum budget in this column and individual node groups (a tree branch). The second summary displays the sum of all values within the Budget column and individual node groups.

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 TreeList stores its summary items within the Summary collection.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxTreeListDemos