Edit

Share via

CubeField.Orientation property (Excel)

  • Article

Returns or sets an XlPivotFieldOrientation value that represents the location of the field in the specified PivotTable report.

Syntax

expression.Orientation

expression A variable that represents a CubeField object.

Remarks

For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy.

Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area.

Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.