Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_PivotAreaReference
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-pivotTableShared.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottableshared_xsd Drilldown into x in schema sml-pivottableshared_xsd Drilldown into varPSubtotal in schema sml-pivottableshared_xsd Drilldown into varSubtotal in schema sml-pivottableshared_xsd Drilldown into stdDevPSubtotal in schema sml-pivottableshared_xsd Drilldown into stdDevSubtotal in schema sml-pivottableshared_xsd Drilldown into countSubtotal in schema sml-pivottableshared_xsd Drilldown into productSubtotal in schema sml-pivottableshared_xsd Drilldown into minSubtotal in schema sml-pivottableshared_xsd Drilldown into maxSubtotal in schema sml-pivottableshared_xsd Drilldown into avgSubtotal in schema sml-pivottableshared_xsd Drilldown into countASubtotal in schema sml-pivottableshared_xsd Drilldown into sumSubtotal in schema sml-pivottableshared_xsd Drilldown into defaultSubtotal in schema sml-pivottableshared_xsd Drilldown into relative in schema sml-pivottableshared_xsd Drilldown into byPosition in schema sml-pivottableshared_xsd Drilldown into selected in schema sml-pivottableshared_xsd Drilldown into count in schema sml-pivottableshared_xsd Drilldown into field in schema sml-pivottableshared_xsdXSD Diagram of CT_PivotAreaReference in schema sml-pivottableshared_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_PivotAreaReference">
    <xsd:sequence>
        <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_Index">
            <xsd:annotation>
                <xsd:documentation>Field Item</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="field" use="optional" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Field Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="count" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Item Index Count</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="selected" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Selected</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="byPosition" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Positional Reference</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="relative" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Relative Reference</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Default Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sumSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Sum Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="countASubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include CountA Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="avgSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Average Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="maxSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Maximum Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Minimum Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="productSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Product Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="countSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Count Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stdDevSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include StdDev Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stdDevPSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include StdDevP Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="varSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Var Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="varPSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include VarP Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
x nsM:x 0 unbounded
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
field nsM:field Optional
count nsM:count (Optional)
selected nsM:selected true (Optional)
byPosition nsM:byPosition false (Optional)
relative nsM:relative false (Optional)
defaultSubtotal nsM:defaultSubtotal false (Optional)
sumSubtotal nsM:sumSubtotal false (Optional)
countASubtotal nsM:countASubtotal false (Optional)
avgSubtotal nsM:avgSubtotal false (Optional)
maxSubtotal nsM:maxSubtotal false (Optional)
minSubtotal nsM:minSubtotal false (Optional)
productSubtotal nsM:productSubtotal false (Optional)
countSubtotal nsM:countSubtotal false (Optional)
stdDevSubtotal nsM:stdDevSubtotal false (Optional)
stdDevPSubtotal nsM:stdDevPSubtotal false (Optional)
varSubtotal nsM:varSubtotal false (Optional)
varPSubtotal nsM:varPSubtotal false (Optional)
Collapse Derivation Tree:
Collapse References:
nsM:reference
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0