Expand Minimize

XlCubeFieldSubType Enumeration (Excel)

Specifies the subtype of the CubeField.

Version Added: Excel 2013

Name

Value

Description

xlCubeAttribute

4

Attribute

xlCubeCalculatedMeasure

5

Calculated Measure

xlCubeHierarchy

1

Hierarchy

xlCubeImplicitMeasure

11

An implicit measure

xlCubeKPIGoal

7

KPI Goal

xlCubeKPIStatus

8

KPI Status

xlCubeKPITrend

9

KPI Trend

xlCubeKPIValue

6

KPI Value

xlCubeKPIWeight

10

KPI Weight

xlCubeMeasure

2

Measure

xlCubeSet

3

Set

Note Note

The values have “Cube” in the name in order to not overlap with the xlMeasure and xlSet values for the CubeFieldType property. If the names are the same, autocomplete will not work in the Visual Basic environment because it finds ambiguous values.

Show:
© 2014 Microsoft