Specifies the type of data that is to appear in this row or column in the PivotTable view.
<ItemType />
Element type | Anonymous |
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
PTLineItem | Describes the layout of one row or column line in the PivotTable view. |
None.
None.
<xsd:element name="ItemType" default="Data" minOccurs="0" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Avg" />
<xsd:enumeration value="Count" />
<xsd:enumeration value="CountNums" />
<xsd:enumeration value="Max" />
<xsd:enumeration value="Min" />
<xsd:enumeration value="Product" />
<xsd:enumeration value="StdDev" />
<xsd:enumeration value="StdDevP" />
<xsd:enumeration value="Sum" />
<xsd:enumeration value="Var" />
<xsd:enumeration value="VarP" />
<xsd:enumeration value="Blank" />
<xsd:enumeration value="Data" />
<xsd:enumeration value="Default" />
<xsd:enumeration value="Grand" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>