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