Definition Type: ComplexType
Name: CT_PivotFilter
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-pivotTable.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottable_xsd Drilldown into autoFilter in schema sml-pivottable_xsd Drilldown into stringValue2 in schema sml-pivottable_xsd Drilldown into stringValue1 in schema sml-pivottable_xsd Drilldown into description in schema sml-pivottable_xsd Drilldown into name in schema sml-pivottable_xsd Drilldown into iMeasureFld in schema sml-pivottable_xsd Drilldown into iMeasureHier in schema sml-pivottable_xsd Drilldown into id in schema sml-pivottable_xsd Drilldown into evalOrder in schema sml-pivottable_xsd Drilldown into type in schema sml-pivottable_xsd Drilldown into mpFld in schema sml-pivottable_xsd Drilldown into fld in schema sml-pivottable_xsdXSD Diagram of CT_PivotFilter in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_PivotFilter">
    <xsd:sequence>
        <xsd:element name="autoFilter" minOccurs="1" maxOccurs="1" type="CT_AutoFilter">
            <xsd:annotation>
                <xsd:documentation>Auto Filter</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="fld" use="required" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Field Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mpFld" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Member Property Field Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="type" use="required" type="ST_PivotFilterType">
        <xsd:annotation>
            <xsd:documentation>Pivot Filter Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="evalOrder" use="optional" type="xsd:int" default="0">
        <xsd:annotation>
            <xsd:documentation>Evaluation Order</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="id" use="required" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Pivot Filter Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="iMeasureHier" use="optional" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Measure Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="iMeasureFld" use="optional" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Measure Field Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="name" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Pivot Filter Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="description" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Pivot Filter Description</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stringValue1" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Label Pivot</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stringValue2" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Label Pivot Filter String Value 2</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
autoFilter nsM:autoFilter 1 1
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
fld nsM:fld Required
mpFld nsM:mpFld Optional
type nsM:type Required
evalOrder nsM:evalOrder 0 Optional
id nsM:id Required
iMeasureHier nsM:iMeasureHier Optional
iMeasureFld nsM:iMeasureFld Optional
name nsM:name (Optional)
description nsM:description (Optional)
stringValue1 nsM:stringValue1 (Optional)
stringValue2 nsM:stringValue2 (Optional)
Collapse Derivation Tree:
Collapse References:
nsM:filter