ssml:pivotHierarchy

OLAP Hierarchy

Element information

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

Schema document: sml-pivotTable.xsd

Type: ssml:CT_PivotHierarchy

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:mps [0..1] OLAP Member Properties
2. ssml:members [0..*] Members
3. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
outline	[0..1]	xsd:boolean	Outline New Levels	Default value is "false".
multipleItemSelectionAllowed	[0..1]	xsd:boolean	Multiple Field Filters	Default value is "false".
subtotalTop	[0..1]	xsd:boolean	New Levels Subtotals At Top	Default value is "false".
showInFieldList	[0..1]	xsd:boolean	Show In Field List	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".
dragToPage	[0..1]	xsd:boolean	Drag to Page	Default value is "true".
dragToData	[0..1]	xsd:boolean	Drag To Data	Default value is "false".
dragOff	[0..1]	xsd:boolean	Drag Off	Default value is "true".
includeNewItemsInFilter	[0..1]	xsd:boolean	Inclusive Manual Filter	Default value is "false".
caption	[0..1]	ssml:ST_Xstring	Hierarchy Caption

Used in

Type ssml:CT_PivotHierarchies (Element ssml:pivotHierarchies)

Sample instance

<ssml:pivotHierarchy>
   <ssml:mps>
      <ssml:mp field="1"/>
   </ssml:mps>
   <ssml:members>
      <ssml:member name="string"/>
   </ssml:members>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:pivotHierarchy>