Aggregates Object (ExPivot)

The Aggregates collection holds the aggregate functions the user can use and display in the pivot control. The Aggregates property gets access to Aggregate objects to define aggregate functions like sum, avg, min, max, count. The Aggregate objects are displayed ( as radio buttons ) on the control's context menu as shown:

The Aggregates collection supports the following properties and methods:

		Name	Description
		Add	Adds an Aggregate function and returns a reference to the newly created object.
		Clear	Removes all objects in a collection.
		Count	Returns the number of objects in a collection.
		Item	Returns a specific Aggregate function giving its key.
		Remove	Removes a specific member from the collection.