Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_PivotField
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 autoSortScope in schema sml-pivottable_xsd Drilldown into items in schema sml-pivottable_xsd Drilldown into defaultAttributeDrillState in schema sml-pivottable_xsd Drilldown into showPropAsCaption in schema sml-pivottable_xsd Drilldown into showPropTip in schema sml-pivottable_xsd Drilldown into showPropCell in schema sml-pivottable_xsd Drilldown into varPSubtotal in schema sml-pivottable_xsd Drilldown into varSubtotal in schema sml-pivottable_xsd Drilldown into stdDevPSubtotal in schema sml-pivottable_xsd Drilldown into stdDevSubtotal in schema sml-pivottable_xsd Drilldown into countSubtotal in schema sml-pivottable_xsd Drilldown into productSubtotal in schema sml-pivottable_xsd Drilldown into minSubtotal in schema sml-pivottable_xsd Drilldown into maxSubtotal in schema sml-pivottable_xsd Drilldown into avgSubtotal in schema sml-pivottable_xsd Drilldown into countASubtotal in schema sml-pivottable_xsd Drilldown into sumSubtotal in schema sml-pivottable_xsd Drilldown into defaultSubtotal in schema sml-pivottable_xsd Drilldown into rankBy in schema sml-pivottable_xsd Drilldown into nonAutoSortDefault in schema sml-pivottable_xsd Drilldown into dataSourceSort in schema sml-pivottable_xsd Drilldown into sortType in schema sml-pivottable_xsd Drilldown into itemPageCount in schema sml-pivottable_xsd Drilldown into includeNewItemsInFilter in schema sml-pivottable_xsd Drilldown into measureFilter in schema sml-pivottable_xsd Drilldown into hideNewItems in schema sml-pivottable_xsd Drilldown into topAutoShow in schema sml-pivottable_xsd Drilldown into autoShow in schema sml-pivottable_xsd Drilldown into insertPageBreak in schema sml-pivottable_xsd Drilldown into serverField in schema sml-pivottable_xsd Drilldown into insertBlankRow in schema sml-pivottable_xsd Drilldown into showAll 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 multipleItemSelectionAllowed in schema sml-pivottable_xsd Drilldown into dragToCol in schema sml-pivottable_xsd Drilldown into dragToRow in schema sml-pivottable_xsd Drilldown into subtotalTop in schema sml-pivottable_xsd Drilldown into outline in schema sml-pivottable_xsd Drilldown into numFmtId in schema sml-pivottable_xsd Drilldown into allDrilled in schema sml-pivottable_xsd Drilldown into compact in schema sml-pivottable_xsd Drilldown into uniqueMemberProperty in schema sml-pivottable_xsd Drilldown into hiddenLevel in schema sml-pivottable_xsd Drilldown into showDropDowns in schema sml-pivottable_xsd Drilldown into subtotalCaption in schema sml-pivottable_xsd Drilldown into dataField in schema sml-pivottable_xsd Drilldown into axis in schema sml-pivottable_xsd Drilldown into name in schema sml-pivottable_xsdXSD Diagram of CT_PivotField in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_PivotField">
    <xsd:sequence>
        <xsd:element name="items" minOccurs="0" type="CT_Items">
            <xsd:annotation>
                <xsd:documentation>Field Items</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="autoSortScope" minOccurs="0" type="CT_AutoSortScope">
            <xsd:annotation>
                <xsd:documentation>AutoSort Scope</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" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Field Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="axis" use="optional" type="ST_Axis">
        <xsd:annotation>
            <xsd:documentation>Axis</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataField" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Data Field</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotalCaption" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Custom Subtotal Caption</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDropDowns" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show PivotField Header Drop Downs</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hiddenLevel" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Hidden Level</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="uniqueMemberProperty" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Unique Member Property</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="compact" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Compact</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="allDrilled" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>All Items Expanded</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional">
        <xsd:annotation>
            <xsd:documentation>Number Format Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="outline" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Outline Items</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotalTop" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Subtotals At Top</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="multipleItemSelectionAllowed" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Multiple Field Filters</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToPage" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Drag Field to Page</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToData" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Field Can 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="showAll" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show All Items</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="insertBlankRow" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Insert Blank Row</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="serverField" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Server-based Page Field</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="insertPageBreak" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Insert Item Page Break</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="autoShow" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Auto Show</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="topAutoShow" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Top Auto Show</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hideNewItems" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Hide New Items</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measureFilter" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Measure Filter</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="itemPageCount" type="xsd:unsignedInt" default="10">
        <xsd:annotation>
            <xsd:documentation>Items Per Page Count</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sortType" type="ST_FieldSortType" default="manual">
        <xsd:annotation>
            <xsd:documentation>Auto Sort Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataSourceSort" type="xsd:boolean" use="optional">
        <xsd:annotation>
            <xsd:documentation>Data Source Sort</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="nonAutoSortDefault" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Auto Sort</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rankBy" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Auto Show Rank By</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultSubtotal" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Default Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sumSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Sum Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="countASubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>CountA</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="avgSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Average</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="maxSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Max Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Min Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="productSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Product Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="countSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Count</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stdDevSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>StdDev Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stdDevPSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>StdDevP Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="varSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Variance Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="varPSubtotal" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>VarP Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showPropCell" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Member Property in Cell</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showPropTip" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Member Property ToolTip</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showPropAsCaption" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show As Caption</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultAttributeDrillState" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Drill State</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
items nsM:items 0 (1)
autoSortScope nsM:autoSortScope 0 (1)
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
name nsM:name (Optional)
axis nsM:axis Optional
dataField nsM:dataField false (Optional)
subtotalCaption nsM:subtotalCaption (Optional)
showDropDowns nsM:showDropDowns true (Optional)
hiddenLevel nsM:hiddenLevel false (Optional)
uniqueMemberProperty nsM:uniqueMemberProperty (Optional)
compact nsM:compact true (Optional)
allDrilled nsM:allDrilled false (Optional)
numFmtId nsM:numFmtId Optional
outline nsM:outline true (Optional)
subtotalTop nsM:subtotalTop true (Optional)
dragToRow nsM:dragToRow true (Optional)
dragToCol nsM:dragToCol true (Optional)
multipleItemSelectionAllowed nsM:multipleItemSelectionAllowed false (Optional)
dragToPage nsM:dragToPage true (Optional)
dragToData nsM:dragToData true (Optional)
dragOff nsM:dragOff true (Optional)
showAll nsM:showAll true (Optional)
insertBlankRow nsM:insertBlankRow false (Optional)
serverField nsM:serverField false (Optional)
insertPageBreak nsM:insertPageBreak false (Optional)
autoShow nsM:autoShow false (Optional)
topAutoShow nsM:topAutoShow true (Optional)
hideNewItems nsM:hideNewItems false (Optional)
measureFilter nsM:measureFilter false (Optional)
includeNewItemsInFilter nsM:includeNewItemsInFilter false (Optional)
itemPageCount nsM:itemPageCount 10 (Optional)
sortType nsM:sortType manual (Optional)
dataSourceSort nsM:dataSourceSort Optional
nonAutoSortDefault nsM:nonAutoSortDefault false (Optional)
rankBy nsM:rankBy Optional
defaultSubtotal nsM:defaultSubtotal true (Optional)
sumSubtotal nsM:sumSubtotal false (Optional)
countASubtotal nsM:countASubtotal false (Optional)
avgSubtotal nsM:avgSubtotal false (Optional)
maxSubtotal nsM:maxSubtotal false (Optional)
minSubtotal nsM:minSubtotal false (Optional)
productSubtotal nsM:productSubtotal false (Optional)
countSubtotal nsM:countSubtotal false (Optional)
stdDevSubtotal nsM:stdDevSubtotal false (Optional)
stdDevPSubtotal nsM:stdDevPSubtotal false (Optional)
varSubtotal nsM:varSubtotal false (Optional)
varPSubtotal nsM:varPSubtotal false (Optional)
showPropCell nsM:showPropCell false Optional
showPropTip nsM:showPropTip false Optional
showPropAsCaption nsM:showPropAsCaption false Optional
defaultAttributeDrillState nsM:defaultAttributeDrillState false Optional
Collapse Derivation Tree:
Collapse References:
nsM:pivotField
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0