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