ssml:CT_pivotTableDefinition

Complex type information

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

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".

Used by

Element ssml:pivotTableDefinition