Aggregate Object (ExPivot)

The Aggregate object defines an aggregate function to be used by the control. An aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement such as a set, a bag or a list. The Aggregates property gets access to Aggregate objects to define aggregate functions like sum, avg, min, max, count, unique. The Aggregate objects are displayed ( as radio buttons ) on the control's context menu as shown:

The Aggregate object supports the following properties and methods:

		Name	Description
		Base	Specifies the name of the Base Aggregate function to be used by current Aggregate object.
		Caption	Specifies the caption of the Aggregate to be displayed on the column.
		FormatResult	Specifies the expression to be applied on the result of the aggregate function.
		FormatValue	Specifies the expression to be applied on the value before passing to the aggregate function.
		Key	Indicates the key of the Aggregate object.
		Name	Specifies the name of the Aggregate to be displayed on the context menu.
		ToolTip	Specifies the tooltip of the Aggregate to be displayed when the cursor hovers the object.