<rowFields> (Row Fields)

Represents the collection of row fields for the PivotTable.

In the image above, the blue field is a row field. A PivotTable report that has more than one row field has one inner row field (Sport, in the example below), the one closest to the data area. Any other row fields are outer row fields (Region, in the example below). Items in the outermost row field are displayed only once, but items in the rest of the row fields are repeated as needed.

In the image above, Region is an outer row field. Sport is an inner row field.

<rowFields count="2">
  <field x="7"/>
  <field x="8"/>

Parent Elements


Child Elements


<field> (Field)




<count> (Repeated Items Count)

Specifies the number of repeated items in the collection.

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

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

<complexType name="CT_RowFields">
	<element name="field" maxOccurs="unbounded" type="CT_Field"/>
	<attribute name="count" type="xsd:unsignedInt" default="0"/>