PivotTotal Object

Multiple objects PivotTotal Multiple objects

Represents a total in a PivotTable list. A total is the aggregate value that is displayed for the contents of a given cell.

Using the PivotTotal Object

The following properties and methods return a PivotTotal object:

• The PivotAggregate object's Total property

• The PivotField object's FilterOn and SortOn properties

• The PivotTotals object's Item property

• The PivotView object's AddCalculatedTotal and AddTotal methods

Properties | AutoFit Property | Caption Property | CaptionHAlignment Property | DisplayInFieldList Property | Expression Property | Field Property | Function Property | HAlignment Property | Name Property | NumberFormat Property | ShowAs Property | SolveOrder Property | Type Property | UniqueName Property | View Property | Width Property

Parent Objects | PivotAggregate Object | PivotField Object | PivotTotals Collection

Child Objects | PivotField Object | PivotView Object