PivotFieldSet Object

Multiple objects PivotFieldSet Multiple objects

Represents a set of fields that have been locked together to form a hierarchy. For example, in a field set for geography, the fields might be Continent, Country/Region, State, and City—in that order. Typically, a field set will only contain a single field if the data source is a recordset.

Using the PivotFieldSet Object

The following properties and method return a PivotFieldSet object:

• The PivotField object's FieldSet property.

• The PivotFieldSets object's Item property.

• The PivotView object's AddFieldSet method.

Properties | AllIncludeExclude Property | AllMember Property | AllowMultiFilter Property | AlwaysIncludeInCube Property | BoundField Property | Caption Property | CompareMemberCaptionsBy Property | CompareOrderedMembersBy Property | DefaultMember Property | DisplayInFieldList Property | Fields Property | FilterCaption Property | FindMember Property | Member Property | Name Property | Orientation Property | Type Property | UniqueName Property | View Property | Width Property

Methods | AddCalculatedField Method | AddCustomGroupField Method | DeleteField Method

Parent Objects | PivotField Object | PivotFieldSets Collection

Child Objects | PivotField Object | PivotFields Object | PivotMember Object | PivotView Object