<pivotFields> (PivotTable Fields)

Represents the collection of fields that appear on the PivotTable.

<pivotFields count="28">
  <pivotField showAll="0" includeNewItemsInFilter="1">
    <items count="8">
      <item x="66"/>
      <item x="133"/>
      <item x="74"/>
      <item x="27"/>
      <item x="118"/>
      <item x="63"/>
      <item x="141"/>
      <item t="default"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField axis="axisPage" showAll="0" includeNewItemsInFilter="1">
    <items count="2">
      <item x="0"/>
      <item t="default"/>
<pivotField showAll="0" includeNewItemsInFilter="1"/>

Parent Elements


Child Elements


<pivotField> (PivotTable Field)




<count> (Field Count)

Specifies the number of fields in the PivotTable.

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_PivotFields">
	<element name="pivotField" maxOccurs="unbounded" type="CT_PivotField"/>
	<attribute name="count" type="xsd:unsignedInt"/>