pivotFields (PivotTable Fields)

Represents the collection of fields that appear on the PivotTable.

[Example:

<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"/>
</items>

</pivotField>

<pivotField showAll="0" includeNewItemsInFilter="1"/>

<pivotField axis="axisPage" showAll="0" includeNewItemsInFilter="1">
<items count="2">
<item x="0"/>
<item t="default"/>
</items>
</pivotField>
<pivotField showAll="0" includeNewItemsInFilter="1"/>

end example]

Parent Elements

pivotTableDefinition (§3.10.1.73)

 

Child Elements	Subclause
pivotField (PivotTable Field)	§3.10.1.69

 

Attributes	Description
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">

   <sequence>

   <element name="pivotField" maxOccurs="unbounded" type="CT_PivotField"/>

   </sequence>

   <attribute name="count" type="xsd:unsignedInt"/>

</complexType>