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