DataField Element (Microsoft Excel)

Specifies whether a PivotTable field is a data field, or contains the index number of an aggregate field defined by the PTLineItem element.

Contained In

PivotField, PTLineItem

Remarks

If DataField is a subelement of a PTLineItem element, the DataField element contains an integer. If the DataField element is not specified, the default data field index is 1.

For a PivotTable field, if <x:DataField/> is specified, the field is a data field.

Example

See the example in the PivotTable element topic.