ssml:CT_PivotAreaReference
Complex type information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-pivotTableShared.xsd
Content
- Sequence [1..1]
- ssml:x [0..*] Field Item
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| field | [0..1] | xsd:unsignedInt | Field Index | |
| count | [0..1] | xsd:unsignedInt | Item Index Count | |
| selected | [0..1] | xsd:boolean | Selected | Default value is "true". |
| byPosition | [0..1] | xsd:boolean | Positional Reference | Default value is "false". |
| relative | [0..1] | xsd:boolean | Relative Reference | Default value is "false". |
| defaultSubtotal | [0..1] | xsd:boolean | Include Default Filter | Default value is "false". |
| sumSubtotal | [0..1] | xsd:boolean | Include Sum Filter | Default value is "false". |
| countASubtotal | [0..1] | xsd:boolean | Include CountA Filter | Default value is "false". |
| avgSubtotal | [0..1] | xsd:boolean | Include Average Filter | Default value is "false". |
| maxSubtotal | [0..1] | xsd:boolean | Include Maximum Filter | Default value is "false". |
| minSubtotal | [0..1] | xsd:boolean | Include Minimum Filter | Default value is "false". |
| productSubtotal | [0..1] | xsd:boolean | Include Product Filter | Default value is "false". |
| countSubtotal | [0..1] | xsd:boolean | Include Count Subtotal | Default value is "false". |
| stdDevSubtotal | [0..1] | xsd:boolean | Include StdDev Filter | Default value is "false". |
| stdDevPSubtotal | [0..1] | xsd:boolean | Include StdDevP Filter | Default value is "false". |
| varSubtotal | [0..1] | xsd:boolean | Include Var Filter | Default value is "false". |
| varPSubtotal | [0..1] | xsd:boolean | Include VarP Filter | Default value is "false". |
Used by
- Element ssml:reference