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