Skip to content

Latest commit

 

History

History
52 lines (29 loc) · 1.58 KB

Excel.CubeField.FlattenHierarchies.md

File metadata and controls

52 lines (29 loc) · 1.58 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
CubeField.FlattenHierarchies property (Excel)
vbaxl10.chm668103
vbaxl10.chm668103
Excel.CubeField.FlattenHierarchies
bb97acc3-199b-6c40-e5b5-d411eb40b7e6
04/23/2019
medium

CubeField.FlattenHierarchies property (Excel)

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

Syntax

expression.FlattenHierarchies

expression A variable that represents a CubeField object.

Return value

Boolean

Remarks

True if all hierarchies of the specified 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 on the Layout & Print tab of the Field Settings dialog box for a named set in a PivotTable report that is based on an OLAP cube.

This property returns an error if the CubeFieldType property of the specified CubeField object is not xlSet (XlCubeFieldType enumeration).

Example

The following code example flattens the hierarchies of the specified cube field so that all levels are displayed in the same field of the PivotTable.

ActiveSheet.PivotTables("PivotTable1").CubeFields("[Summary P&L]"). _ 
 FlattenHierarchies = True

[!includeSupport and feedback]