Share via

2.4.104 aggregationInfo

  • Article

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

A CT_AggregationInfo element that specifies the aggregation function for the PivotTable data field. If this element is present, the subtotal attribute of the associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) data field item ([ISO/IEC29500-1:2016] section 18.10.1.22) SHOULDf<6> be ignored.

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

 <xsd:element name="aggregationInfo" type="CT_AggregationInfo"/>

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