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.