Share via

2.7.39 ST_AggregationType

  • Article

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

Referenced by: CT_AggregationInfo

This simple type specifies an aggregation function applied to a PivotTable data field.

Value

Meaning

distinctCount

The count of unique values in the source PivotTable field

median

The middle value in the source PivotTable field

distinctDuplicates

The count of distinct duplicate values in the source PivotTable field

countValuesDuplicated

The count of duplicate values, excluding the first in the source PivotTable field

countRepeatValues

The count of duplicate values, including the first in the source PivotTable field

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

 <xsd:simpleType name="ST_AggregationType">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="distinctCount"/>
     <xsd:enumeration value="median"/>
     <xsd:enumeration value="distinctDuplicates"/>
     <xsd:enumeration value="countValuesDuplicated"/>
     <xsd:enumeration value="countRepeatValues"/>
   </xsd:restriction>
 </xsd:simpleType>

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