THEMES
THEME SETTINGS

Tree List - Data Summary Data Summary via 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 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.

Version: v2017 vol 1.3
Copyright © 2006-2017 Developer Express Inc
Your Next Great MVC App Starts Here

Get started today and download your 30-day trial of DevExpress MVC Extensions (includes 30 days of free technical support).

All demos ship with full source code and are included in the DevExpress MVC distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress MVC Extensions ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.