The subtotal aggregation functions that can be applied to a pivot field.
Beware of the 'count' false cognate: here it means "count of numeric values" (like the COUNT
worksheet function), while in PivotDataFieldAggregation'count' means "count of
non-empty values" (like the COUNTA worksheet function).
The subtotal aggregation functions that can be applied to a pivot field.
Beware of the
'count'false cognate: here it means "count of numeric values" (like the COUNT worksheet function), while in PivotDataFieldAggregation'count'means "count of non-empty values" (like the COUNTA worksheet function).