CalculatedMember.FlattenHierarchies property (Excel)

Returns or sets whether items from all levels of the hierarchy of the specified named set are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write Boolean.

Syntax

expression.FlattenHierarchies

expression A variable that represents a CalculatedMember object.

Return value

Boolean

Remarks

True if items from all levels of the hierarchy of the named set are displayed in the same field; otherwise, False.

The value of this property corresponds to the setting of the Display items from different levels in separate fields check box in the New/Modify Set dialog box when a named set is created or edited.

To create a new named set from data in a PivotTable based on an OLAP data source, choose the PivotTable, choose Field, Items, & Sets on the PivotTable Tools Options tab on the ribbon, choose Manage Sets, choose New in the Set Manager dialog box, and then choose Create Set using MDX.

This will display the New Set dialog box, which contains the Display items from different levels in separate fields check box. Similarly, if you select an existing named set in the Set Manager dialog box, and then choose Edit, the Modify Set dialog box is displaye

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.