ssml:pivotField

PivotTable Field

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-pivotTable.xsd

Type: ssml:CT_PivotField

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:items [0..1] Field Items
2. ssml:autoSortScope [0..1] AutoSort Scope
3. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
name	[0..1]	ssml:ST_Xstring	Field Name
axis	[0..1]	ssml:ST_Axis	Axis
dataField	[0..1]	xsd:boolean	Data Field	Default value is "false".
subtotalCaption	[0..1]	ssml:ST_Xstring	Custom Subtotal Caption
showDropDowns	[0..1]	xsd:boolean	Show PivotField Header Drop Downs	Default value is "true".
hiddenLevel	[0..1]	xsd:boolean	Hidden Level	Default value is "false".
uniqueMemberProperty	[0..1]	ssml:ST_Xstring	Unique Member Property
compact	[0..1]	xsd:boolean	Compact	Default value is "true".
allDrilled	[0..1]	xsd:boolean	All Items Expanded	Default value is "false".
numFmtId	[0..1]	ssml:ST_NumFmtId	Number Format Id
outline	[0..1]	xsd:boolean	Outline Items	Default value is "true".
subtotalTop	[0..1]	xsd:boolean	Subtotals At Top	Default value is "true".
dragToRow	[0..1]	xsd:boolean	Drag To Row	Default value is "true".
dragToCol	[0..1]	xsd:boolean	Drag To Column	Default value is "true".
multipleItemSelectionAllowed	[0..1]	xsd:boolean	Multiple Field Filters	Default value is "false".
dragToPage	[0..1]	xsd:boolean	Drag Field to Page	Default value is "true".
dragToData	[0..1]	xsd:boolean	Field Can Drag to Data	Default value is "true".
dragOff	[0..1]	xsd:boolean	Drag Off	Default value is "true".
showAll	[0..1]	xsd:boolean	Show All Items	Default value is "true".
insertBlankRow	[0..1]	xsd:boolean	Insert Blank Row	Default value is "false".
serverField	[0..1]	xsd:boolean	Server-based Page Field	Default value is "false".
insertPageBreak	[0..1]	xsd:boolean	Insert Item Page Break	Default value is "false".
autoShow	[0..1]	xsd:boolean	Auto Show	Default value is "false".
topAutoShow	[0..1]	xsd:boolean	Top Auto Show	Default value is "true".
hideNewItems	[0..1]	xsd:boolean	Hide New Items	Default value is "false".
measureFilter	[0..1]	xsd:boolean	Measure Filter	Default value is "false".
includeNewItemsInFilter	[0..1]	xsd:boolean	Inclusive Manual Filter	Default value is "false".
itemPageCount	[0..1]	xsd:unsignedInt	Items Per Page Count	Default value is "10".
sortType	[0..1]	ssml:ST_FieldSortType	Auto Sort Type	Default value is "manual".
dataSourceSort	[0..1]	xsd:boolean	Data Source Sort
nonAutoSortDefault	[0..1]	xsd:boolean	Auto Sort	Default value is "false".
rankBy	[0..1]	xsd:unsignedInt	Auto Show Rank By
defaultSubtotal	[0..1]	xsd:boolean	Show Default Subtotal	Default value is "true".
sumSubtotal	[0..1]	xsd:boolean	Sum Subtotal	Default value is "false".
countASubtotal	[0..1]	xsd:boolean	CountA	Default value is "false".
avgSubtotal	[0..1]	xsd:boolean	Average	Default value is "false".
maxSubtotal	[0..1]	xsd:boolean	Max Subtotal	Default value is "false".
minSubtotal	[0..1]	xsd:boolean	Min Subtotal	Default value is "false".
productSubtotal	[0..1]	xsd:boolean	Product Subtotal	Default value is "false".
countSubtotal	[0..1]	xsd:boolean	Count	Default value is "false".
stdDevSubtotal	[0..1]	xsd:boolean	StdDev Subtotal	Default value is "false".
stdDevPSubtotal	[0..1]	xsd:boolean	StdDevP Subtotal	Default value is "false".
varSubtotal	[0..1]	xsd:boolean	Variance Subtotal	Default value is "false".
varPSubtotal	[0..1]	xsd:boolean	VarP Subtotal	Default value is "false".
showPropCell	[0..1]	xsd:boolean	Show Member Property in Cell	Default value is "false".
showPropTip	[0..1]	xsd:boolean	Show Member Property ToolTip	Default value is "false".
showPropAsCaption	[0..1]	xsd:boolean	Show As Caption	Default value is "false".
defaultAttributeDrillState	[0..1]	xsd:boolean	Drill State	Default value is "false".

Used in

Type ssml:CT_PivotFields (Element ssml:pivotFields)

Sample instance

<ssml:pivotField>
   <ssml:items>
      <ssml:item/>
   </ssml:items>
   <ssml:autoSortScope>
      <ssml:pivotArea>
         <ssml:references>...
         </ssml:references>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:pivotArea>
   </ssml:autoSortScope>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:pivotField>