Definition Type: Element
Name: pivotHierarchy
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:CT_PivotHierarchy
Containing Schema: sml-pivotTable.xsd
MinOccurs (1)
MaxOccurs unbounded
Abstract
Documentation:
OLAP Hierarchy
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_xsd Drilldown into CT_PivotHierarchy in schema sml-pivottable_xsdXSD Diagram of pivotHierarchy in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:element name="pivotHierarchy" maxOccurs="unbounded" type="CT_PivotHierarchy">
    <xsd:annotation>
        <xsd:documentation>OLAP Hierarchy</xsd:documentation>
    </xsd:annotation>
</xsd:element>
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: