PivotFieldSet Object

                  Properties                 

PivotFieldSets collection (PivotFieldSet object)
PivotFields collection (PivotField object)
PivotMembers collection (PivotMember object)

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, State, and City—in that order. Typically, a field set will only contain a single field if the data source is a recordset. The PivotFieldSet object is a member of the PivotFieldSets collection.

Using the PivotFieldSet Object

The following properties return a PivotFieldSet object:

The PivotField object’s FieldSet property

The PivotFieldSets object’s Item property