ssml:CT_PivotHierarchy
Complex type information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-pivotTable.xsd
Content
- Sequence [1..1]
- ssml:mps [0..1] OLAP Member Properties
- ssml:members [0..*] Members
- 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 by
- Element ssml:pivotHierarchy