CubeField.HierarchizeDistinct Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets whether to order and remove duplicates when displaying 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 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.

Applies to