CubeField Methods (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

AddMemberPropertyField

Adds a member property field to the display for the cube field.

AutoGroup

Automatically groups the cube fields in an OLAP cube, optionally in the specified orientation and/or at the specified position.

ClearManualFilter

The ClearManualFilter method provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList/VisibleItemsList collections in OLAP PivotTables.

CreatePivotFields

The CreatePivotFields method enables users to apply a filter to PivotFields not yet added to the PivotTable by creating the corresponding PivotField object.

Delete

Deletes the object.

Show: