PivotTable.AddDataField method (Excel)

Artikkeli
09/13/2021

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.

Jaa