CalculatedMember.HierarchizeDistinct Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Gets or sets whether to order and remove duplicates when displaying the hierarchy of the specified named set in a PivotTable report based on an OLAP cube.

public:
 property bool HierarchizeDistinct { bool get(); void set(bool value); };

public bool HierarchizeDistinct { get; set; }

Public Property HierarchizeDistinct As Boolean

Property Value

Boolean

true if duplicates should be ordered and removed when displaying the hierarchy of the specified named set in a PivotTable report based on an OLAP cube; otherwise, false.

Remarks

Read/write.

true if the hierarchy of the named set is displayed as ordered with duplicates removed; otherwise false.

The value of this property corresponds to the Automatically order and remove duplicates from the set 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, click the PivotTable, click Field, Items, & Sets on the PivotTable Tools Options tab on the ribbon, click Manage Sets, click New in the Set Manager dialog box, and then click Create Set using MDX. This will display the New Set dialog box, which contains the Automatically order and remove duplicates from the set check box. Similarly, if you select an existing named set in the Set Manager dialog box, and then click Edit, the Modify Set dialog box is displayed.

This property along with the DisplayFolder and Dynamic properties can only be read for named sets (which are represented by CalculatedMember objects where the Type property equals xlCalculatedSet). These properties for cannot be read for calculated members or measures (which are represented by CalculatedMember objects where the Type property equals xlCalculatedMember). If you attempt to read these properties for calculated members or measures, a run-time error is raised.