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>:

  • @showAll flag indicating whether to show all items for this field.

  • @includeNewItemsInFilter Flag indicating if new items in the data source are included in the filter automatically after refresh when there was at least one hidden item for the field.

  • @axis indicates on which axis this field is shown on the PivotTable.

  • @dataField indicates that this field is in the values area of the PivotTable.

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 <item x="66"/>,which references the value " " in the pivotCacheDefinition. Therefore if one added "Customer Name" to the row axis, " " would be the first row item listed.

In the context of <item>:

  • @t value of 'default' indicates the subtotal or total item.