PivotTable.AddDataField method (Excel)
Adds a data field to a PivotTable report. Returns a PivotField object that represents the new data field.
Syntax
expression.AddDataField (Field, Caption, Function)
expression A variable that represents a PivotTable object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Field | Required | Object | The unique field on the server. If the source data is Online Analytical Processing (OLAP), the unique field is a cube field. If the source data is non-OLAP (non-OLAP source data), the unique field is a PivotTable field. |
| Caption | Optional | Variant | The label used in the PivotTable report to identify this data field. |
| Function | Optional | Variant | The function performed in the added data field. |
Return value
PivotField
Example
This example adds a data field titled Total Score to a PivotTable called PivotTable1. This example assumes that a table exists in which one of the columns contains a column titled Score.
Sub AddMoreFields()
With ActiveSheet.PivotTables("PivotTable1")
.AddDataField ActiveSheet.PivotTables( _
"PivotTable1").PivotFields("Score"), "Total Score"
End With
End Sub
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.