Aggregate.Base Property (ExPivot)

The Base property indicates the base aggregate function to be used by the current Aggregate object. If the Base property points to an unknown value, the Aggregate object shows as disabled in the control's context menu.

The Base property could be one on the following:

sum, summation is the operation of adding a sequence of numbers; the result is their sum or total
min, minimum is the smallest value
max, maximum is the largest value
count, counts the number of objects in the set
avg, average is the arithmetic mean, which means sum of all numbers divided by the count.

		Type	Description
		String	A String expression that defines the base aggregate function to be used by the current Aggregate object. Any of the following values are supported. In case an unknown base function is used, the Aggregate object shows as disabled in the control's context menu.