Free Trial Buy Now

Data Summary - Built-in Functions

 DepartmentLocationBudget
[Collapse]Corporate HeadquartersMonterey$1,000,000.00
 [Collapse]Sales and MarketingSan Francisco$22,000.00
   Field Office: CanadaToronto$500,000.00
   Field Office: East CoastBoston$500,000.00
  [Expand]Pacific 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
 [Collapse]EngineeringMonterey$1,100,000.00
  [Expand]Consumer Electronics Div.Burlington, VT$1,150,000.00
  [Expand]Software 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

Description

The ASPxTreeList 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 ASPxTreeList provides five built-in aggregate functions (count, max, min, etc.).

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

Version: v2011 vol 2.11
Experience the DevExpress Difference Today
To download your free evaluation copy of our award-winning ASP.NET libraries, visit the Downloads page
All DevExpress ASP.NET Controls ship as part of DXperience ASP.NET, Enterprise, and Universal.
To obtain pricing information, visit the Pricing Options page or contact us via Email at info@devexpress.com
or by telephone at +1 (818) 844-3383 between 8:30am and 5pm Pacific Time.