ssml:pivotTableDefinition

PivotTable Definition

Element information

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

Schema document: sml-pivotTable.xsd

Type: ssml:CT_pivotTableDefinition

Properties: Global, Qualified

Content

Sequence [1..1]
1. ssml:location [1..1] PivotTable Location
2. ssml:pivotFields [0..1] PivotTable Fields
3. ssml:rowFields [0..1] Row Fields
4. ssml:rowItems [0..1] Row Items
5. ssml:colFields [0..1] Column Fields
6. ssml:colItems [0..1] Column Items
7. ssml:pageFields [0..1] Page Field Items
8. ssml:dataFields [0..1] Data Fields
9. ssml:formats [0..1] PivotTable Formats
10. ssml:conditionalFormats [0..1] Conditional Formats
11. ssml:chartFormats [0..1] PivotChart Formats
12. ssml:pivotHierarchies [0..1] PivotTable OLAP Hierarchies
13. ssml:pivotTableStyleInfo [0..1] PivotTable Style
14. ssml:filters [0..1] Filters
15. ssml:rowHierarchiesUsage [0..1] Row OLAP Hierarchy References
16. ssml:colHierarchiesUsage [0..1] Column OLAP Hierarchy References
17. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
name	[1..1]	ssml:ST_Xstring	Name
cacheId	[1..1]	xsd:unsignedInt	PivotCache Definition Id
dataOnRows	[0..1]	xsd:boolean	Data On Rows	Default value is "false".
dataPosition	[0..1]	xsd:unsignedInt	Default Data Field Position
autoFormatId	[0..1]	xsd:unsignedInt	Auto Format Id	from group ssml:AG_AutoFormat
applyNumberFormats	[0..1]	xsd:boolean	Apply Number Formats	from group ssml:AG_AutoFormat
applyBorderFormats	[0..1]	xsd:boolean	Apply Border Formats	from group ssml:AG_AutoFormat
applyFontFormats	[0..1]	xsd:boolean	Apply Font Formats	from group ssml:AG_AutoFormat
applyPatternFormats	[0..1]	xsd:boolean	Apply Pattern Formats	from group ssml:AG_AutoFormat
applyAlignmentFormats	[0..1]	xsd:boolean	Apply Alignment Formats	from group ssml:AG_AutoFormat
applyWidthHeightFormats	[0..1]	xsd:boolean	Apply Width / Height Formats	from group ssml:AG_AutoFormat
dataCaption	[1..1]	ssml:ST_Xstring	Data Field Header Name
grandTotalCaption	[0..1]	ssml:ST_Xstring	Grand Totals Caption
errorCaption	[0..1]	ssml:ST_Xstring	Error Caption
showError	[0..1]	xsd:boolean	Show Error	Default value is "false".
missingCaption	[0..1]	ssml:ST_Xstring	Caption for Missing Values
showMissing	[0..1]	xsd:boolean	Show Missing	Default value is "true".
pageStyle	[0..1]	ssml:ST_Xstring	Page Header Style Name
pivotTableStyle	[0..1]	ssml:ST_Xstring	Table Style Name
vacatedStyle	[0..1]	ssml:ST_Xstring	Vacated Style
tag	[0..1]	ssml:ST_Xstring	PivotTable Custom String
updatedVersion	[0..1]	xsd:unsignedByte	PivotTable Last Updated Version	Default value is "0".
minRefreshableVersion	[0..1]	xsd:unsignedByte	Minimum Refreshable Version	Default value is "0".
asteriskTotals	[0..1]	xsd:boolean	Asterisk Totals	Default value is "false".
showItems	[0..1]	xsd:boolean	Show Item Names	Default value is "true".
editData	[0..1]	xsd:boolean	Allow Edit Data	Default value is "false".
disableFieldList	[0..1]	xsd:boolean	Disable Field List	Default value is "false".
showCalcMbrs	[0..1]	xsd:boolean	Show Calculated Members	Default value is "true".
visualTotals	[0..1]	xsd:boolean	Total Visual Data	Default value is "true".
showMultipleLabel	[0..1]	xsd:boolean	Show Multiple Labels	Default value is "true".
showDataDropDown	[0..1]	xsd:boolean	Show Drop Down	Default value is "true".
showDrill	[0..1]	xsd:boolean	Show Expand Collapse	Default value is "true".
printDrill	[0..1]	xsd:boolean	Print Drill Indicators	Default value is "false".
showMemberPropertyTips	[0..1]	xsd:boolean	Show Member Property ToolTips	Default value is "true".
showDataTips	[0..1]	xsd:boolean	Show ToolTips on Data	Default value is "true".
enableWizard	[0..1]	xsd:boolean	Enable PivotTable Wizard	Default value is "true".
enableDrill	[0..1]	xsd:boolean	Enable Drill Down	Default value is "true".
enableFieldProperties	[0..1]	xsd:boolean	Enable Field Properties	Default value is "true".
preserveFormatting	[0..1]	xsd:boolean	Preserve Formatting	Default value is "true".
useAutoFormatting	[0..1]	xsd:boolean	Auto Formatting	Default value is "false".
pageWrap	[0..1]	xsd:unsignedInt	Page Wrap	Default value is "0".
pageOverThenDown	[0..1]	xsd:boolean	Page Over Then Down	Default value is "false".
subtotalHiddenItems	[0..1]	xsd:boolean	Subtotal Hidden Items	Default value is "false".
rowGrandTotals	[0..1]	xsd:boolean	Row Grand Totals	Default value is "true".
colGrandTotals	[0..1]	xsd:boolean	Grand Totals On Columns	Default value is "true".
fieldPrintTitles	[0..1]	xsd:boolean	Field Print Titles	Default value is "false".
itemPrintTitles	[0..1]	xsd:boolean	Item Print Titles	Default value is "false".
mergeItem	[0..1]	xsd:boolean	Merge Titles	Default value is "false".
showDropZones	[0..1]	xsd:boolean	Show Drop Zones	Default value is "true".
createdVersion	[0..1]	xsd:unsignedByte	PivotCache Created Version	Default value is "0".
indent	[0..1]	xsd:unsignedInt	Indentation for Compact Axis	Default value is "1".
showEmptyRow	[0..1]	xsd:boolean	Show Empty Row	Default value is "false".
showEmptyCol	[0..1]	xsd:boolean	Show Empty Column	Default value is "false".
showHeaders	[0..1]	xsd:boolean	Show Field Headers	Default value is "true".
compact	[0..1]	xsd:boolean	Compact New Fields	Default value is "true".
outline	[0..1]	xsd:boolean	Outline New Fields	Default value is "false".
outlineData	[0..1]	xsd:boolean	Outline Data Fields	Default value is "false".
compactData	[0..1]	xsd:boolean	Compact Data	Default value is "true".
published	[0..1]	xsd:boolean	Data Fields Published	Default value is "false".
gridDropZones	[0..1]	xsd:boolean	Enable Drop Zones	Default value is "false".
immersive	[0..1]	xsd:boolean	Stop Immersive UI	Default value is "true".
multipleFieldFilters	[0..1]	xsd:boolean	Multiple Field Filters	Default value is "true".
chartFormat	[0..1]	xsd:unsignedInt	Chart Format Id	Default value is "0".
rowHeaderCaption	[0..1]	ssml:ST_Xstring	Row Header Caption
colHeaderCaption	[0..1]	ssml:ST_Xstring	Column Header Caption
fieldListSortAscending	[0..1]	xsd:boolean	Default Sort Order	Default value is "false".
mdxSubqueries	[0..1]	xsd:boolean	MDX Subqueries Supported	Default value is "false".
customListSort	[0..1]	xsd:boolean	Custom List AutoSort	Default value is "true".

Sample instance

<ssml:pivotTableDefinition name="string" cacheId="1" dataCaption="string">
   <ssml:location ref="string" firstHeaderRow="1" firstDataRow="1" firstDataCol="1"/>
   <ssml:pivotFields>
      <ssml:pivotField>
         <ssml:items>...
         </ssml:items>
         <ssml:autoSortScope>...
         </ssml:autoSortScope>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:pivotField>
   </ssml:pivotFields>
   <ssml:rowFields>
      <ssml:field x="1"/>
   </ssml:rowFields>
   <ssml:rowItems>
      <ssml:i>
         <ssml:x/>
      </ssml:i>
   </ssml:rowItems>
   <ssml:colFields>
      <ssml:field x="1"/>
   </ssml:colFields>
   <ssml:colItems>
      <ssml:i>
         <ssml:x/>
      </ssml:i>
   </ssml:colItems>
   <ssml:pageFields>
      <ssml:pageField fld="1" item="1">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:pageField>
   </ssml:pageFields>
   <ssml:dataFields>
      <ssml:dataField fld="1">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:dataField>
   </ssml:dataFields>
   <ssml:formats>
      <ssml:format>
         <ssml:pivotArea>...
         </ssml:pivotArea>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:format>
   </ssml:formats>
   <ssml:conditionalFormats>
      <ssml:conditionalFormat priority="1">
         <ssml:pivotAreas>...
         </ssml:pivotAreas>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:conditionalFormat>
   </ssml:conditionalFormats>
   <ssml:chartFormats>
      <ssml:chartFormat chart="1" format="1">
         <ssml:pivotArea>...
         </ssml:pivotArea>
      </ssml:chartFormat>
   </ssml:chartFormats>
   <ssml:pivotHierarchies>
      <ssml:pivotHierarchy>
         <ssml:mps>...
         </ssml:mps>
         <ssml:members>...
         </ssml:members>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:pivotHierarchy>
   </ssml:pivotHierarchies>
   <ssml:pivotTableStyleInfo/>
   <ssml:filters>
      <ssml:filter fld="1" type="unknown" id="1">
         <ssml:autoFilter>...
         </ssml:autoFilter>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:filter>
   </ssml:filters>
   <ssml:rowHierarchiesUsage>
      <ssml:rowHierarchyUsage hierarchyUsage="1"/>
   </ssml:rowHierarchiesUsage>
   <ssml:colHierarchiesUsage>
      <ssml:colHierarchyUsage hierarchyUsage="1"/>
   </ssml:colHierarchiesUsage>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:pivotTableDefinition>