Share via

2.7.12 ST_AllocationMethod

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_PivotTableDefinition, CT_PivotChange

A simple type that specifies the method of allocation for PivotTable what-if analysis.

Value

Meaning

equalAllocation

Equal allocation

equalIncrement

Equal increment

weightedAllocation

Weighted allocation

weightedIncrement

Weighted increment

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

 <xsd:simpleType name="ST_AllocationMethod">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="equalAllocation"/>
     <xsd:enumeration value="equalIncrement"/>
     <xsd:enumeration value="weightedAllocation"/>
     <xsd:enumeration value="weightedIncrement"/>
   </xsd:restriction>
 </xsd:simpleType>

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