CubeField.PivotFields Property

Syntax

expression.PivotFields

expression An expression that returns a CubeField object.

Return Value
PivotFields

Remarks

For Online Analytical Processing (OLAP) data sources, there are no hidden fields, and the object or collection that's returned reflects what's currently visible.

Example

This example creates a list of all the PivotTable field names used in the first PivotChart report.

Set objNewSheet = Worksheets.Add objNewSheet.Activate intRow = 1 For Each objPF In _ Charts("Chart1").PivotLayout.PivotFields objNewSheet.Cells(intRow, 1).Value = objPF.Caption intRow = intRow + 1 Next objPF

See also:

• CubeField Object
• CubeField Object Members
• ColumnFields Property
• DataFields Property
• HiddenFields Property
• PageFields Property
• RowFields Property
• VisibleFields Property