Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: Element
Name: pivotTableDefinition
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:CT_pivotTableDefinition
Containing Schema: sml-pivotTable.xsd
Abstract
Documentation:
PivotTable Definition
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottable_xsd Drilldown into colHierarchiesUsage in schema sml-pivottable_xsd Drilldown into rowHierarchiesUsage in schema sml-pivottable_xsd Drilldown into filters in schema sml-pivottable_xsd Drilldown into pivotTableStyleInfo in schema sml-pivottable_xsd Drilldown into pivotHierarchies in schema sml-pivottable_xsd Drilldown into chartFormats in schema sml-pivottable_xsd Drilldown into conditionalFormats in schema sml-pivottable_xsd Drilldown into formats in schema sml-pivottable_xsd Drilldown into dataFields in schema sml-pivottable_xsd Drilldown into pageFields in schema sml-pivottable_xsd Drilldown into colItems in schema sml-pivottable_xsd Drilldown into colFields in schema sml-pivottable_xsd Drilldown into rowItems in schema sml-pivottable_xsd Drilldown into rowFields in schema sml-pivottable_xsd Drilldown into pivotFields in schema sml-pivottable_xsd Drilldown into location in schema sml-pivottable_xsd Drilldown into customListSort in schema sml-pivottable_xsd Drilldown into mdxSubqueries in schema sml-pivottable_xsd Drilldown into fieldListSortAscending in schema sml-pivottable_xsd Drilldown into colHeaderCaption in schema sml-pivottable_xsd Drilldown into rowHeaderCaption in schema sml-pivottable_xsd Drilldown into chartFormat in schema sml-pivottable_xsd Drilldown into multipleFieldFilters in schema sml-pivottable_xsd Drilldown into immersive in schema sml-pivottable_xsd Drilldown into gridDropZones in schema sml-pivottable_xsd Drilldown into published in schema sml-pivottable_xsd Drilldown into compactData in schema sml-pivottable_xsd Drilldown into outlineData in schema sml-pivottable_xsd Drilldown into outline in schema sml-pivottable_xsd Drilldown into compact in schema sml-pivottable_xsd Drilldown into showHeaders in schema sml-pivottable_xsd Drilldown into showEmptyCol in schema sml-pivottable_xsd Drilldown into showEmptyRow in schema sml-pivottable_xsd Drilldown into indent in schema sml-pivottable_xsd Drilldown into createdVersion in schema sml-pivottable_xsd Drilldown into showDropZones in schema sml-pivottable_xsd Drilldown into mergeItem in schema sml-pivottable_xsd Drilldown into itemPrintTitles in schema sml-pivottable_xsd Drilldown into fieldPrintTitles in schema sml-pivottable_xsd Drilldown into colGrandTotals in schema sml-pivottable_xsd Drilldown into rowGrandTotals in schema sml-pivottable_xsd Drilldown into subtotalHiddenItems in schema sml-pivottable_xsd Drilldown into pageOverThenDown in schema sml-pivottable_xsd Drilldown into pageWrap in schema sml-pivottable_xsd Drilldown into useAutoFormatting in schema sml-pivottable_xsd Drilldown into preserveFormatting in schema sml-pivottable_xsd Drilldown into enableFieldProperties in schema sml-pivottable_xsd Drilldown into enableDrill in schema sml-pivottable_xsd Drilldown into enableWizard in schema sml-pivottable_xsd Drilldown into showDataTips in schema sml-pivottable_xsd Drilldown into showMemberPropertyTips in schema sml-pivottable_xsd Drilldown into printDrill in schema sml-pivottable_xsd Drilldown into showDrill in schema sml-pivottable_xsd Drilldown into showDataDropDown in schema sml-pivottable_xsd Drilldown into showMultipleLabel in schema sml-pivottable_xsd Drilldown into visualTotals in schema sml-pivottable_xsd Drilldown into showCalcMbrs in schema sml-pivottable_xsd Drilldown into disableFieldList in schema sml-pivottable_xsd Drilldown into editData in schema sml-pivottable_xsd Drilldown into showItems in schema sml-pivottable_xsd Drilldown into asteriskTotals in schema sml-pivottable_xsd Drilldown into minRefreshableVersion in schema sml-pivottable_xsd Drilldown into updatedVersion in schema sml-pivottable_xsd Drilldown into tag in schema sml-pivottable_xsd Drilldown into vacatedStyle in schema sml-pivottable_xsd Drilldown into pivotTableStyle in schema sml-pivottable_xsd Drilldown into pageStyle in schema sml-pivottable_xsd Drilldown into showMissing in schema sml-pivottable_xsd Drilldown into missingCaption in schema sml-pivottable_xsd Drilldown into showError in schema sml-pivottable_xsd Drilldown into errorCaption in schema sml-pivottable_xsd Drilldown into grandTotalCaption in schema sml-pivottable_xsd Drilldown into dataCaption in schema sml-pivottable_xsd Drilldown into applyWidthHeightFormats in schema sml-styles_xsd Drilldown into applyAlignmentFormats in schema sml-styles_xsd Drilldown into applyPatternFormats in schema sml-styles_xsd Drilldown into applyFontFormats in schema sml-styles_xsd Drilldown into applyBorderFormats in schema sml-styles_xsd Drilldown into applyNumberFormats in schema sml-styles_xsd Drilldown into autoFormatId in schema sml-styles_xsd Drilldown into AG_AutoFormat in schema sml-styles_xsd Drilldown into dataPosition in schema sml-pivottable_xsd Drilldown into dataOnRows in schema sml-pivottable_xsd Drilldown into cacheId in schema sml-pivottable_xsd Drilldown into name in schema sml-pivottable_xsd Drilldown into CT_pivotTableDefinition in schema sml-pivottable_xsdXSD Diagram of pivotTableDefinition in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:element name="pivotTableDefinition" type="CT_pivotTableDefinition">
    <xsd:annotation>
        <xsd:documentation>PivotTable Definition</xsd:documentation>
    </xsd:annotation>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
location nsM:location (1) (1)
pivotFields nsM:pivotFields 0 (1)
rowFields nsM:rowFields 0 (1)
rowItems nsM:rowItems 0 (1)
colFields nsM:colFields 0 (1)
colItems nsM:colItems 0 (1)
pageFields nsM:pageFields 0 (1)
dataFields nsM:dataFields 0 (1)
formats nsM:formats 0 (1)
conditionalFormats nsM:conditionalFormats 0 (1)
chartFormats nsM:chartFormats 0 (1)
pivotHierarchies nsM:pivotHierarchies 0 (1)
pivotTableStyleInfo nsM:pivotTableStyleInfo 0 1
filters nsM:filters 0 1
rowHierarchiesUsage nsM:rowHierarchiesUsage 0 1
colHierarchiesUsage nsM:colHierarchiesUsage 0 1
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
name nsM:name Required
cacheId nsM:cacheId Required
dataOnRows nsM:dataOnRows false (Optional)
dataPosition nsM:dataPosition Optional
autoFormatId nsM:autoFormatId (Optional)
applyNumberFormats nsM:applyNumberFormats (Optional)
applyBorderFormats nsM:applyBorderFormats (Optional)
applyFontFormats nsM:applyFontFormats (Optional)
applyPatternFormats nsM:applyPatternFormats (Optional)
applyAlignmentFormats nsM:applyAlignmentFormats (Optional)
applyWidthHeightFormats nsM:applyWidthHeightFormats (Optional)
dataCaption nsM:dataCaption Required
grandTotalCaption nsM:grandTotalCaption (Optional)
errorCaption nsM:errorCaption (Optional)
showError nsM:showError false (Optional)
missingCaption nsM:missingCaption (Optional)
showMissing nsM:showMissing true (Optional)
pageStyle nsM:pageStyle (Optional)
pivotTableStyle nsM:pivotTableStyle (Optional)
vacatedStyle nsM:vacatedStyle (Optional)
tag nsM:tag (Optional)
updatedVersion nsM:updatedVersion 0 (Optional)
minRefreshableVersion nsM:minRefreshableVersion 0 (Optional)
asteriskTotals nsM:asteriskTotals false (Optional)
showItems nsM:showItems true (Optional)
editData nsM:editData false (Optional)
disableFieldList nsM:disableFieldList false (Optional)
showCalcMbrs nsM:showCalcMbrs true (Optional)
visualTotals nsM:visualTotals true (Optional)
showMultipleLabel nsM:showMultipleLabel true (Optional)
showDataDropDown nsM:showDataDropDown true (Optional)
showDrill nsM:showDrill true (Optional)
printDrill nsM:printDrill false (Optional)
showMemberPropertyTips nsM:showMemberPropertyTips true (Optional)
showDataTips nsM:showDataTips true (Optional)
enableWizard nsM:enableWizard true (Optional)
enableDrill nsM:enableDrill true (Optional)
enableFieldProperties nsM:enableFieldProperties true (Optional)
preserveFormatting nsM:preserveFormatting true (Optional)
useAutoFormatting nsM:useAutoFormatting false (Optional)
pageWrap nsM:pageWrap 0 (Optional)
pageOverThenDown nsM:pageOverThenDown false (Optional)
subtotalHiddenItems nsM:subtotalHiddenItems false (Optional)
rowGrandTotals nsM:rowGrandTotals true (Optional)
colGrandTotals nsM:colGrandTotals true (Optional)
fieldPrintTitles nsM:fieldPrintTitles false (Optional)
itemPrintTitles nsM:itemPrintTitles false (Optional)
mergeItem nsM:mergeItem false (Optional)
showDropZones nsM:showDropZones true (Optional)
createdVersion nsM:createdVersion 0 (Optional)
indent nsM:indent 1 (Optional)
showEmptyRow nsM:showEmptyRow false (Optional)
showEmptyCol nsM:showEmptyCol false (Optional)
showHeaders nsM:showHeaders true (Optional)
compact nsM:compact true (Optional)
outline nsM:outline false (Optional)
outlineData nsM:outlineData false (Optional)
compactData nsM:compactData true (Optional)
published nsM:published false (Optional)
gridDropZones nsM:gridDropZones false (Optional)
immersive nsM:immersive true (Optional)
multipleFieldFilters nsM:multipleFieldFilters true (Optional)
chartFormat nsM:chartFormat 0 (Optional)
rowHeaderCaption nsM:rowHeaderCaption (Optional)
colHeaderCaption nsM:colHeaderCaption (Optional)
fieldListSortAscending nsM:fieldListSortAscending false (Optional)
mdxSubqueries nsM:mdxSubqueries false (Optional)
customListSort nsM:customListSort true Optional
Collapse Derivation Tree:
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0