Represents the data associated with a total in a PivotTable list. A total defines what the user wants to see, but the data that results from the total is called the aggregate or aggregate value. The PivotAggregate object is a member of the PivotAggregates collection.
Using the PivotAggregate Object
The PivotAggregates collection’s Item property returns a PivotAggregate object.