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