PivotAggregate Object

PivotCell PivotAggregates PivotAggregate Multiple objects

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.

Properties | Cell Property | Name Property | ProviderFormattedValue Property | ShowAsValue Property | Text Property | Total Property | Value Property

Parent Objects | PivotCell

Child Objects | PivotCell | PivotTotal