Values Area Fields

This collection describes which fields are found in the values area of the PivotTable.

<dataFields count="1">
  <dataField name="Sum of Sales Amount" fld="25" baseField="0" baseItem="0"/>
</dataFields>

In the context of <dataField>:

• @name is the name of the values field.

• @fld is the index of the field being summarized.

• @baseField is the index of the base field when @showDataAs calculation is in use.

• @baseItem is the index of the base item when @showDataAs calculation is in use.