<field> (Field)

Represents a generic field that can appear either on the column or the row region of the PivotTable. There will be as many <x> elements as there are item values in any particular column or row.

example:
<sh:field x="2"/>

Parent Elements

<colFields>3.10.1.14); <rowFields>3.10.1.81)

Attributes

Description

<x> (Field Index)

Specifies the index to a <pivotField> item value. There will be as many <x> elements as there are item values in any particular column. Note that these <x> elements sometimes are not explicitly written, but instead "inherited" from the previous column or <i> element, via the value of <@r>. The <pivotField> items don't list values explicitly, but instead reference a shared item value in the <pivotCacheDefinition> part. The first instance of <x> has no attribute value <@v> associated with it, so the default value for <@v> is assumed to be "0".

The possible values for this attribute are defined by the XML Schema int datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Field">
	<attribute name="x" type="xsd:int" use="required"/>
</complexType>