Office Open XML
L Annex L. (informative) Primer
L.2 Introduction to SpreadsheetML
L.2.2 Sheets
L.2.9.3.4.3 PivotTable Fields

L.2.9.3.4.3 PivotTable Fields

This collection expresses item order and field information for each field associated with the PivotTable, whether shown in the PivotTable report or not. (Note that items have been removed from the “Customer Name” and “City” fields (1st and 6th) to shorten the 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"/>
  <pivotField axis="axisPage" showAll="0" includeNewItemsInFilter="1">
    <items count="6">
      <item x="3"/>
      <item x="1"/>
      <item x="2"/>
      <item x="4"/>
      <item x="0"/>
      <item t="default"/>
    </items>
  </pivotField>
  <pivotField axis="axisPage" showAll="0" includeNewItemsInFilter="1">
    <items count="8">
      <item x="0"/>
      <item x="1"/>
      <item x="2"/>
      <item x="3"/>
      <item x="4"/>
      <item x="5"/>
      <item x="6"/>
      <item t="default"/>
    </items>
  </pivotField>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField axis="axisRow" showAll="0" includeNewItemsInFilter="1">
    <items count="2">
      <item x="0"/>
      <item t="default"/>
    </items>
  </pivotField>
  <pivotField axis="axisRow" showAll="0" includeNewItemsInFilter="1">
    <items count="3">
      <item x="1"/>
      <item x="0"/>
      <item t="default"/>
    </items>
  </pivotField>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField axis="axisCol" showAll="0" includeNewItemsInFilter="1">
    <items count="2">
      <item x="0"/>
      <item t="default"/>
    </items>
  </pivotField>
  <pivotField axis="axisCol" showAll="0" includeNewItemsInFilter="1">
    <items count="2">
      <item x="0"/>
      <item t="default"/>
    </items>
  </pivotField>
  <pivotField axis="axisCol" showAll="0" includeNewItemsInFilter="1">
    <items count="4">
      <item x="1"/>
      <item x="2"/>
      <item x="0"/>
      <item t="default"/>
    </items>
  </pivotField>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField dataField="1" showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
  <pivotField showAll="0" includeNewItemsInFilter="1"/>
</pivotFields>

In the context of pivotField:

In the context of items, which is a listing of items (by index) in this field. The order in which the items are listed is the order they would appear on a particular axis (row or column, for example). In this example, the first field is “Customer Name” and the first item referenced here is ,which references the value “Adam L Flores” in the pivotCacheDefinition. Therefore if one added “Customer Name” to the row axis, “Adam L Flores” would be the first row item listed.

In the context of item:

Last updated on
L.2.9.3.3 XML - pivotCacheRecords partL.3.1.2.3 Direction