Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_PivotHierarchy
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 members in schema sml-pivottable_xsd Drilldown into mps in schema sml-pivottable_xsd Drilldown into caption in schema sml-pivottable_xsd Drilldown into includeNewItemsInFilter in schema sml-pivottable_xsd Drilldown into dragOff in schema sml-pivottable_xsd Drilldown into dragToData in schema sml-pivottable_xsd Drilldown into dragToPage in schema sml-pivottable_xsd Drilldown into dragToCol in schema sml-pivottable_xsd Drilldown into dragToRow in schema sml-pivottable_xsd Drilldown into showInFieldList in schema sml-pivottable_xsd Drilldown into subtotalTop in schema sml-pivottable_xsd Drilldown into multipleItemSelectionAllowed in schema sml-pivottable_xsd Drilldown into outline in schema sml-pivottable_xsdXSD Diagram of CT_PivotHierarchy in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_PivotHierarchy">
    <xsd:sequence>
        <xsd:element name="mps" minOccurs="0" type="CT_MemberProperties">
            <xsd:annotation>
                <xsd:documentation>OLAP Member Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="members" minOccurs="0" maxOccurs="unbounded" type="CT_Members">
            <xsd:annotation>
                <xsd:documentation>Members</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="outline" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Outline New Levels</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="multipleItemSelectionAllowed" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Multiple Field Filters</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotalTop" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>New Levels Subtotals At Top</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showInFieldList" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show In Field List</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToRow" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Drag To Row</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToCol" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Drag To Column</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToPage" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Drag to Page</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToData" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Drag To Data</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragOff" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Drag Off</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="includeNewItemsInFilter" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Inclusive Manual Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Hierarchy Caption</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
mps nsM:mps 0 (1)
members nsM:members 0 unbounded
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
outline nsM:outline false (Optional)
multipleItemSelectionAllowed nsM:multipleItemSelectionAllowed false (Optional)
subtotalTop nsM:subtotalTop false (Optional)
showInFieldList nsM:showInFieldList true (Optional)
dragToRow nsM:dragToRow true (Optional)
dragToCol nsM:dragToCol true (Optional)
dragToPage nsM:dragToPage true (Optional)
dragToData nsM:dragToData false (Optional)
dragOff nsM:dragOff true (Optional)
includeNewItemsInFilter nsM:includeNewItemsInFilter false (Optional)
caption nsM:caption Optional
Collapse Derivation Tree:
Collapse References:
nsM:pivotHierarchy
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0