Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_pivotTableDefinition
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 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_xsdXSD Diagram of CT_pivotTableDefinition in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_pivotTableDefinition">
    <xsd:sequence>
        <xsd:element name="location" type="CT_Location">
            <xsd:annotation>
                <xsd:documentation>PivotTable Location</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pivotFields" type="CT_PivotFields" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>PivotTable Fields</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="rowFields" type="CT_RowFields" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Row Fields</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="rowItems" type="CT_rowItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Row Items</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="colFields" type="CT_ColFields" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Column Fields</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="colItems" type="CT_colItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Column Items</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pageFields" type="CT_PageFields" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Page Field Items</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="dataFields" type="CT_DataFields" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Data Fields</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="formats" type="CT_Formats" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>PivotTable Formats</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="conditionalFormats" type="CT_ConditionalFormats" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Conditional Formats</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="chartFormats" type="CT_ChartFormats" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>PivotChart Formats</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pivotHierarchies" type="CT_PivotHierarchies" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>PivotTable OLAP Hierarchies</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pivotTableStyleInfo" minOccurs="0" maxOccurs="1" type="CT_PivotTableStyle">
            <xsd:annotation>
                <xsd:documentation>PivotTable Style</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="filters" minOccurs="0" maxOccurs="1" type="CT_PivotFilters">
            <xsd:annotation>
                <xsd:documentation>Filters</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="rowHierarchiesUsage" type="CT_RowHierarchiesUsage" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Row OLAP Hierarchy References</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="colHierarchiesUsage" type="CT_ColHierarchiesUsage" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Column OLAP Hierarchy References</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="name" use="required" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cacheId" use="required" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>PivotCache Definition Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataOnRows" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Data On Rows</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataPosition" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Default Data Field Position</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attributeGroup ref="AG_AutoFormat" />
    <xsd:attribute name="dataCaption" use="required" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Data Field Header Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="grandTotalCaption" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Grand Totals Caption</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="errorCaption" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Error Caption</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showError" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Error</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="missingCaption" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Caption for Missing Values</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showMissing" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Missing</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pageStyle" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Page Header Style Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pivotTableStyle" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Table Style Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="vacatedStyle" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Vacated Style</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="tag" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>PivotTable Custom String</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="updatedVersion" type="xsd:unsignedByte" default="0">
        <xsd:annotation>
            <xsd:documentation>PivotTable Last Updated Version</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minRefreshableVersion" type="xsd:unsignedByte" default="0">
        <xsd:annotation>
            <xsd:documentation>Minimum Refreshable Version</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="asteriskTotals" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Asterisk Totals</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showItems" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Item Names</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="editData" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Allow Edit Data</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="disableFieldList" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Disable Field List</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showCalcMbrs" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Calculated Members</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="visualTotals" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Total Visual Data</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showMultipleLabel" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Multiple Labels</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDataDropDown" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Drop Down</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDrill" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Expand Collapse</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="printDrill" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Print Drill Indicators</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showMemberPropertyTips" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Member Property ToolTips</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDataTips" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show ToolTips on Data</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="enableWizard" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Enable PivotTable Wizard</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="enableDrill" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Enable Drill Down</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="enableFieldProperties" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Enable Field Properties</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="preserveFormatting" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Preserve Formatting</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="useAutoFormatting" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Auto Formatting</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pageWrap" type="xsd:unsignedInt" default="0">
        <xsd:annotation>
            <xsd:documentation>Page Wrap</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pageOverThenDown" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Page Over Then Down</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotalHiddenItems" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Subtotal Hidden Items</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rowGrandTotals" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Row Grand Totals</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="colGrandTotals" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Grand Totals On Columns</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fieldPrintTitles" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Field Print Titles</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="itemPrintTitles" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Item Print Titles</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mergeItem" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Merge Titles</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDropZones" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Drop Zones</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="createdVersion" type="xsd:unsignedByte" default="0">
        <xsd:annotation>
            <xsd:documentation>PivotCache Created Version</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="indent" type="xsd:unsignedInt" default="1">
        <xsd:annotation>
            <xsd:documentation>Indentation for Compact Axis</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showEmptyRow" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Empty Row</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showEmptyCol" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Empty Column</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showHeaders" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Field Headers</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="compact" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Compact New Fields</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="outline" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Outline New Fields</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="outlineData" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Outline Data Fields</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="compactData" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Compact Data</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="published" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Data Fields Published</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="gridDropZones" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Enable Drop Zones</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="immersive" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Stop Immersive UI</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="multipleFieldFilters" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Multiple Field Filters</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="chartFormat" type="xsd:unsignedInt" default="0">
        <xsd:annotation>
            <xsd:documentation>Chart Format Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rowHeaderCaption" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Row Header Caption</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="colHeaderCaption" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Column Header Caption</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fieldListSortAscending" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Default Sort Order</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mdxSubqueries" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>MDX Subqueries Supported</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="customListSort" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Custom List AutoSort</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
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:
Collapse References:
nsM:pivotTableDefinition
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0