Share via

2.7.6 ST_PivotShowAs

  • Article

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

Referenced by: CT_DataField

This simple type specifies the display format values for a PivotTable ([ISO/IEC29500-1:2016] section 18.10) field.

Value

Meaning

percentOfParent

Percentage of parent total.

percentOfParentRow

Percentage of parent row total.

percentOfParentCol

Percentage of parent column total.

percentOfRunningTotal

Percentage of running total.

rankAscending

Rank ascending.

rankDescending

Rank descending.

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

 <xsd:simpleType name="ST_PivotShowAs">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="percentOfParent"/>
     <xsd:enumeration value="percentOfParentRow"/>
     <xsd:enumeration value="percentOfParentCol"/>
     <xsd:enumeration value="percentOfRunningTotal"/>
     <xsd:enumeration value="rankAscending"/>
     <xsd:enumeration value="rankDescending"/>
   </xsd:restriction>
 </xsd:simpleType>

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