Applying Summaries

• Jan 23, 2019
• 2 minutes to read

End-users can manipulate summaries using context menus. These menus can be invoked by right-clicking a footer cell. Each menu item corresponds to a summary type (sum, average, etc). Clicking an item applies the appropriate summary to the column whose footer cell was clicked. Each summary type applied has a default display format. The table below lists menu items, their corresponding summary types and default format strings.

Menu Item	Effect
Sum	The summary value is the sum of column values. The default format string is “SUM={0:#.##}“.
Min	The summary value is the column’s minimum value. The default format string is “MIN={0}“.
Max	The summary value is the column’s maximum value. The default format string is “MAX={0}“.
Count	The summary value is the number of records within the calculation range. The default format string is “{0}“.
Average	The summary value is the column’s average value. The default format string is “AVR={0:#.##}“.
None	Cancels summary calculation.

Notes:

• The TreeListOptionsView.ShowSummaryFooter option should be enabled to make the view footer visible. The availability of row footers is controlled by the TreeListOptionsView.ShowRowFooterSummary property.
• The content of footer menus can be changed by handling the TreeList.PopupMenuShowing event. Each item’s functionality can be overridden by handling the TreeList.TreeListMenuItemClick event.