PivotField Object

Multiple objects PivotField Multiple objects

Represents a single field in a PivotTable list.

Using the PivotField Object

The following properties and methods return a PivotField object:

• The Field property of the following objects: PivotAxisMember, PivotColumnMember, PivotDetailCell , PivotMember , PivotPageMember, PivotRowMember, and PivotTotal .

• The PivotField object's FilterContext property.

• The PivotFields object's Item property.

• The PivotFieldSet object's AddCalculatedField and AddCustomGroupField methods, and BoundField property.

• The PivotResultField and PivotResultGroupField objects' SourceField property.

Properties | BaseName Property | Caption Property | CustomGroupMembers Property | DataField Property | DataType Property | DefaultValue Property | DetailAutoFit Property | DetailBackColor Property | DetailFont Property | DetailForeColor Property | DetailHAlignment Property | DetailWidth Property | ExcludedMembers Property | Expanded Property | Expression Property | FieldSet Property | FilterContext Property | FilterFunction Property | FilterFunctionValue Property | FilterOn Property | FilterOnScope Property | GroupedAutoFit Property | GroupedBackColor Property | GroupedFont Property | GroupedForeColor Property | GroupedHAlignment Property | GroupedHeight Property | GroupedWidth Property | GroupEnd Property | GroupInterval Property | GroupOn Property | GroupStart Property | IncludedMembers Property | IsHyperlink Property | IsIncluded Property | MemberCaptions Property | MemberProperties Property | MemberPropertiesOrder Property | Name Property | NumberFormat Property | OrderedMembers Property | PropertyCaptionWidth Property | PropertyHeight Property | PropertyValueWidth Property | SortDirection Property | SortOn Property | SortOnScope Property | SubtotalBackColor Property | SubtotalFont Property | SubtotalForeColor Property | SubtotalLabelBackColor Property | SubtotalLabelFont Property | SubtotalLabelForeColor Property | SubtotalLabelHAlignment Property | Subtotals Property | Type Property | UniqueName Property

Methods | AddCustomGroupMember Method | DeleteCustomGroupMember Method

Parent Objects | PivotAxisMember Object | PivotColumnMember Object | PivotDetailCell Object | PivotField Object | PivotFields Collection | PivotFieldSet Object | PivotMember Object | PivotPageMember Object | PivotResultField Object | PivotResultGroupField Object | PivotRowMember Object | PivotTotal Object

Child Objects | PivotField Object | PivotFieldSet Object | PivotFont Object | PivotMemberProperties Object | PivotMembers Object | PivotTotal Object