PivotField.Function property (Excel)
Returns or sets the function used to summarize the PivotTable field (data fields only). Read/write XlConsolidationFunction.
Syntax
expression.Function
expression A variable that represents a PivotField object.
Remarks
For OLAP data sources, this property is read-only and always returns xlUnknown. For other data sources, this property cannot be set to xlUnknown.
Example
This example sets the "Sum of 1994" field in the first PivotTable report on the active sheet to use the SUM function.
ActiveSheet.PivotTables("PivotTable1") _
.PivotFields("Sum of 1994").Function = xlSum
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for