Share via

PivotFields Collection Object

  • Article
Multiple objects
PivotFields
PivotField
Multiple objects

The collection of PivotField objects in the specified field set.

Using the PivotFields Collection

Use the Fields property of the following objects to return a PivotFields collection: PivotDetailRange, PivotFieldSet, PivotResultColumnAxis, PivotResultDataAxis, PivotResultGroupAxis, PivotResultPageAxis, or PivotResultRowAxis.

Properties | Count Property | Item Property

Parent Objects | PivotFieldSet | PivotResultColumnAxis | PivotResultDataAxis | PivotResultGroupAxis | PivotResultPageAxis | PivotResultRowAxis

Child Objects | PivotField | PivotFieldSet | PivotFont | PivotMemberProperties | PivotMembers | PivotTotal