2.6.32 CT_PivotTableDefinition

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: pivotTableDefinition

This element specifies additional properties of a PivotTable ([ISO/IEC29500-1:2016] section 18.10) view.

Child Elements:

pivotEdits: A CT_PivotEdits element that specifies a collection of PivotTable What-if Analysis edits.

pivotChanges: A CT_PivotChanges element that specifies a collection of PivotTable What-if Analysis changes.

conditionalFormats: A CT_ConditionalFormats element that specifies a collection of conditional formats applied to the PivotTable ([ISO/IEC29500-1:2016] section 18.10) view.

Attributes:

fillDownLabelsDefault: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies the behavior of PivotTable ([ISO/IEC29500-1:2016] section 18.10) fields that are not a part of the PivotTable ([ISO/IEC29500-1:2016] section 18.10) view if they are later added to a PivotTable ([ISO/IEC29500-1:2016] section 18.10) view. MUST be a value from the following table.

visualTotalsForSets: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether hidden PivotTable ([ISO/IEC29500-1:2016] section 18.10) items will be included when calculating totals for PivotTable ([ISO/IEC29500-1:2016] section 18.10) named sets. MUST be a value from the following table.

calculatedMembersInFilters: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether PivotTable ([ISO/IEC29500-1:2016] section 18.10) OLAP-calculated members participate in PivotTable ([ISO/IEC29500-1:2016] section 18.10) manual filters and PivotTable ([ISO/IEC29500-1:2016] section 18.10) advanced filters. 

altText: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the alternate text for the PivotTable ([ISO/IEC29500-1:2016] section 18.10) view. The string MUST be less than or equal to 2,000 characters in length.

altTextSummary: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the alternate text summary for the PivotTable ([ISO/IEC29500-1:2016] section 18.10) view. This string MUST be less than or equal to 2,000 characters in length.

enableEdit: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether PivotTable what-if analysis is enabled for the current PivotTable ([ISO/IEC29500-1:2016] section 18.10) view.

autoApply: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether PivotTable what-if analysis values are automatically allocated.

allocationMethod: An ST_AllocationMethod attribute that specifies the allocation method to use for PivotTable what-if analysis.

weightExpression: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the Multidimensional Expressions (MDX) of the weight expression for weighted allocations of PivotTable what-if analysis values. This string MUST be less than or equal to 65,535 characters in length.

hideValuesRow: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether the values row in the PivotTable ([ISO/IEC29500-1:2016] section 18.10) report is visible.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_PivotTableDefinition">
   <xsd:sequence>
     <xsd:element name="pivotEdits" type="CT_PivotEdits" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="pivotChanges" type="CT_PivotChanges" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="conditionalFormats" type="CT_ConditionalFormats" minOccurs="0"/>
   </xsd:sequence>
   <xsd:attribute name="fillDownLabelsDefault" type="xsd:boolean" use="optional" default="false"/>
   <xsd:attribute name="visualTotalsForSets" type="xsd:boolean" use="optional" default="false"/>
   <xsd:attribute name="calculatedMembersInFilters" type="xsd:boolean" use="optional" default="false"/>
   <xsd:attribute name="altText" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="altTextSummary" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="enableEdit" type="xsd:boolean" use="optional" default="false"/>
   <xsd:attribute name="autoApply" type="xsd:boolean" use="optional" default="false"/>
   <xsd:attribute name="allocationMethod" type="ST_AllocationMethod" use="optional" default="equalAllocation"/>
   <xsd:attribute name="weightExpression" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="hideValuesRow" type="xsd:boolean" use="optional" default="false"/>
 </xsd:complexType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).