CubeField.HierarchizeDistinct Property
Gets or sets whether to order and remove duplicates when displaying the specified named set in a PivotTable report based on an OLAP cube.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property HierarchizeDistinct As Boolean
Get
Set
'Usage
Dim instance As CubeField
Dim value As Boolean
value = instance.HierarchizeDistinct
instance.HierarchizeDistinct = value
bool HierarchizeDistinct { get; set; }
Property Value
Type: System.Boolean
true if duplicates should be ordered and removed when displaying the specified named set in a PivotTable report based on an OLAP cube; otherwise, false.
Remarks
Read/write.
true if the named set is displayed as ordered with duplicates removed; otherwise false.
The value of this property corresponds to the setting of the Automatically order and remove duplicates from the set check box on the Layout & Print tab of the Field Settings dialog box for a named set in a PivotTable report based on an OLAP cube.
This property returns an error if the CubeFieldType property of the specified CubeField object is not xlSet.