Share via

2.6.93 CT_CalculatedMember

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_CalculatedMemberExt, calculatedMember

This element adds new properties for supporting calculated members.

Attributes:

measureGroup: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the name of the measure group that this calculated member is associated with if measure is TRUE.

numberFormat: An ST_CalcMemNumberFormat (see section 2.7.25) attribute that specifies the formatting type of the calculated member.

measure: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether this calculated member is also a calculated measure.

Value

Meaning

"true"

This calculated member is also a calculated measure.

"false"

This calculated member is not a calculated measure.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_CalculatedMember">
   <xsd:attribute name="measureGroup" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="numberFormat" type="ST_CalcMemNumberFormat" use="optional" default="default"/>
   <xsd:attribute name="measure" type="xsd:boolean" use="optional" default="false"/>
 </xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).