Share via

2.6.256 CT_AggregationInfo

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2023/pivot2023Calculation

Referenced by: aggregationInfo

This complex type specifies extended information about a PivotTable data field item ([ISO/IEC29500-1:2016] section 18.10.1.22).

Attributes:

aggregationType: An ST_AggregationType attribute that specifies the aggregation type applied to the PivotTable data field if the type is not covered in the subtotal attribution in PivotTable data field.

sourceField:  An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the zero-based index of the CT_PivotField ([ISO/IEC29500-4:2016] section A.2) element in the list of CT_PivotField ([ISO/IEC29500-4:2016] section A.2) elements specified by the CT_PivotFields ([ISO/IEC29500-4:2016] section A.2) element that this data item summarizes.

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

 <xsd:complexType name="CT_AggregationInfo">
   <xsd:attribute name="aggregationType" type="ST_AggregationType" use="required"/>
   <xsd:attribute name="sourceField" type="xsd:unsignedInt" use="required"/>
 </xsd:complexType>

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