CubeField and CubeFields Members

Use the CubeFields collection to get pivot fields from an OLAP pivot table. Use the PivotTable object’s CubeFields property to get a reference to this collection. Use the CubeField object to set the layout and change other properties of fields on an OLAP pivot table. The CubeFields collection and CubeField object provide a subset of the PivotField members ; unique members (shown in bold) are covered in the following reference section:

Warning

CubeFields and CubeField apply only to OLAP pivot tables.

1 Collection only

2 Object and collection

AddMemberPropertyField

AddSet 2

Application 2

Caption

Count 1

Creator 2

CubeFieldType

Delete

DragToColumn

DragToData

DragToHide

DragToPage

DragToRow

EnableMultiplePageItems

HasMemberProperties

HiddenLevels

Item 1

LayoutForm

LayoutSubtotalLocation

Name

Orientation

Parent 2

PivotFields

Position

ShowInFieldList

TreeviewControl

Value

 

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial