Share via

2.6.39 CT_PivotChanges

  • Article

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

Referenced by: CT_PivotTableDefinition

A complex type that specifies the values used for PivotTable what-if analysis calculations and specifies the allocation methods for how to apply the values. It also specifies the collections of MDX unique names that identify the original values in the OLAP data source that were changed.

Child Elements:

pivotChange: A CT_PivotChange element that specifies the value used for PivotTable what-if analysis calculation and specifies the allocation method for how to apply the value. It also specifies a collection of MDX unique names that identifies the original value in the OLAP data source that was changed.

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

 <xsd:complexType name="CT_PivotChanges">
   <xsd:sequence>
     <xsd:element name="pivotChange" minOccurs="1" maxOccurs="unbounded" type="CT_PivotChange"/>
   </xsd:sequence>
 </xsd:complexType>

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