PivotTable.AddDataField(Object, Object, Object) PivotTable.AddDataField(Object, Object, Object) Method

Definition

Adds a data field to a PivotTable report. Returns a PivotField object that represents the new data field.

public Microsoft.Office.Interop.Excel.PivotField AddDataField (object Field, object Caption, object Function);
Public Function AddDataField (Field As Object, Optional Caption As Object, Optional Function As Object) As PivotField

Parameters

Field
Object Object

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
Object Object

Optional Object. The label used in the PivotTable report to identify this data field.

Function
Object Object

Optional Object. The function performed in the added data field.

Returns

Applies to