Definition Type: Element
Name: Subtotal
Namespace: urn:schemas-microsoft-com:office:excel
Type: string:http://www.w3.org/2001/XMLSchema
Containing Schema: excel.xsd
MinOccurs 0
MaxOccurs (1)
Abstract
ContentType Restriction
Documentation:
Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types.
Collapse XSD Schema Diagram:
XSD Diagram of Subtotal in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:element name="Subtotal" minOccurs="0">
    <xsd:annotation>
        <xsd:documentation>Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types.</xsd:documentation>
    </xsd:annotation>
    <xsd:simpleType>
        <xsd:restriction base="xsd:string">
            <xsd:enumeration value="Sum" />
            <xsd:enumeration value="None" />
            <xsd:enumeration value="Default" />
        </xsd:restriction>
    </xsd:simpleType>
</xsd:element>
Collapse Facets:
Facet Value
Enumeration Sum
Enumeration None
Enumeration Default