<pivotField> (PivotTable Field)

Represents a single field in the PivotTable. This complex type contains information about the field, including the collection of items in the field.

example: 
<pivotField axis="axisRow" allDrilled="1" showAll="0" measureFilter="1"
  sortType="descending">
  <items count="8">
    <item s="1" c="1" x="0"/>
    <item s="1" c="1" x="1"/>
    <item c="1" x="2"/>
    <item c="1" x="3"/>
    <item c="1" x="4"/>
    <item c="1" x="5"/>
    <item c="1" x="6"/>
    <item t="default"/>
  </items>
  <autoSortScope>
    <pivotArea dataOnly="0" outline="0" fieldPosition="0">
      <references count="2">
        <reference field="4294967294" count="1" selected="0">
          <x v="0"/>
        </reference>
        <reference field="25" count="1" selected="0">
          <x v="0"/>
        </reference>
      </references>
    </pivotArea>
  </autoSortScope>
</pivotField>

Parent Elements

<pivotFields> (§3.10.1.70)

Child Elements

Subclause

<autoSortScope> (AutoSort Scope)

§3.10.1.1

<extLst> (Future Feature Data Storage Area)

§3.2.10

<items> (Field Items)

§3.10.1.46

Attributes

Description

<allDrilled> (All Items Expanded)

Specifies a boolean value that indicates whether all items in the field are expanded. Applies only to OLAP PivotTables.

A value of on, 1, or true indicates all items in the field are expanded.

A value of off, 0, or false indicates all items are not expanded. However some items may be expanded.

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

<autoShow> (Auto Show)

Specifies a boolean value that indicates whether an "AutoShow" filter is applied to this field. This attribute depends on the implementation of filtering in the application.

A value of on, 1, or true indicates an "AutoShow" filter is applied to the field.

A value of off, 0, or false indicates an "AutoShow" filter is not applied.

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

<avgSubtotal> (Average)

Specifies a boolean value that indicates whether to apply the 'Average' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates the subtotal for this field is 'Average.'

A value of off, 0, or false indicates a different aggregation function is applied to the subtotal for this field.

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

<axis> (Axis)

Specifies the region of the PivotTable that this field is displayed.

The possible values for this attribute are defined by the ST_Axis simple type (§3.18.1).

<compact> (Compact)

Specifies a boolean value that indicates whether the application will display fields compactly in the sheet on which this PivotTable resides.

A value of on, 1, or true indicates the next field should be displayed in the same column of the sheet.

A value of off, 0, or false indicates each pivot field will display in its own column in the sheet.

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

<countASubtotal> (CountA)

Specifies a boolean value that indicates whether to apply the 'countA' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates the subtotal for this field is 'countA.'

A value of off, 0, or false indicates a different aggregation function is applied to the subtotal for this field.

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

<countSubtotal> (Count)

Specifies a boolean value that indicates whether to apply the 'count' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates the subtotal for this field is 'count.'

A value of off, 0, or false indicates a different aggregation vfunction is applied to the subtotal for this field.

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

<dataField> (Data Field)

Specifies a boolean value that indicates whether this field appears in the data region of the PivotTable.

A value of on, 1, or true indicates this field appears in the data region of the PivotTable.

A value of off, 0, or false indicates this field appears in another region of the PivotTable.

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

<dataSourceSort> (Data Source Sort)

Specifies a boolean value that indicates whether sort is applied to this field in the data source.

A value of on, 1, or true indicates this field is sorted in the data source.

A value of off, 0, or false indicates this field is not sorted in the data source.

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

<defaultAttributeDrillState> (Drill State)

Specifies a boolean value that indicates the drill state of the attribute hierarchy in an OLAP-based PivotTable.

A value of on, 1, or true indicates the attribute hierarchy is expanded.

A value of off, 0, or false indicates the attribute hierarchy is collapsed.

This attribute is designed to allow the application to issue more optimized queries when all items of each field have the same drill state.

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

<defaultSubtotal> (Show Default Subtotal)

Specifies a boolean value that indicates whether the default subtotal aggregation function is displayed for this field.

A value of on, 1, or true indicates the default subtotal aggregation function is displayed for this field.

A value of off, 0, or false indicates the default aggregation function is not displayed.

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

<dragOff> (Drag Off)

Specifies a boolean value that indicates whether the field can be removed from the PivotTable.

A value of on, 1, or true indicates the field can be removed from the PivotTable.

A value of off, 0, or false indicates the field cannot be removed from the PivotTable.

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

<dragToCol> (Drag To Column)

Specifies a boolean value that indicates whether the field can be dragged to the column axis.

A value of on, 1, or true indicates the field can be dragged to the column axis.

A value of off, 0, or false indicates the field cannot be dragged to the column axis.

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

<dragToData> (Field Can Drag to Data)

Specifies a boolean value that indicates whether the field can be dragged to the data region.

A value of on, 1, or true indicates the field can be dragged to the data region.

A value of off, 0, or false indicates the field cannot be dragged to the data region.

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

<dragToPage> (Drag Field to Page)

Specifies a boolean value that indicates whether the field can be dragged to the page region.

A value of on, 1, or true indicates the field can be dragged to the page region.

A value of off, 0, or false indicates the field cannot be dragged to the page region.

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

<dragToRow> (Drag To Row)

Specifies a boolean value that indicates whether the field can be dragged to the row axis.

A value of on, 1, or true indicates the field can be dragged to the row axis.

A value of off, 0, or false indicates the field cannot be dragged to the row axis.

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

<hiddenLevel> (Hidden Level)

Specifies a boolean value that indicates whether there is a hidden level in the PivotTable. This attribute applies to OLAP-based PivotTables only.

A value of on, 1, or true indicates the OLAP PivotTable contains a hidden level.

A value of off, 0, or false indicates the OLAP PivotTable does not contain any hidden levels.

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

<hideNewItems> (Hide New Items)

Specifies a boolean value that indicates whether new items that appear after a refresh should be hidden by default.

A value of on, 1, or true indicates that items that appear after a refresh should be hidden by default.

A value of off, 0, or false indicates that items that appear after a refresh should be shown by default.

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

<includeNewItemsInFilter> (Inclusive Manual Filter)

Specifies a boolean value that indicates whether manual filter is in inclusive mode.

A value of on, 1, or true indicates the manual filter is inclusive.

A value of off, 0, or false indicates the manual filter is not inclusive.

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

<insertBlankRow> (Insert Blank Row)

Specifies a boolean value that indicates whether to insert a blank row after each item.

A value of on, 1, or true indicates that a blank row will be inserted after each item.

A value of off, 0, or false indicates no additional rows will be inserted after each item.

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

<insertPageBreak> (Insert Item Page Break)

Specifies a boolean value that indicates whether to insert a page break after each item.

A value of on, 1, or true indicates that a page break will be inserted after each item.

A value of off, 0, or false indicates no page breaks will be inserted after items.

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

<itemPageCount> (Items Per Page Count)

Specifies the number of items showed per page in the PivotTable.

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

<maxSubtotal> (Max Subtotal)

Specifies a boolean value that indicates whether to apply the 'max' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates that the 'max' aggregation function is applied in the subtotal for this field.

A value of off, 0, or false indicates another aggregation function is applied in the subtotal for this field.

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

<measureFilter> (Measure Filter)

Specifies a boolean value that indicates whether field has a measure based filter.

A value of on, 1, or true indicates the field has a measure-based filter.

A value of off, 0, or false indicates does not have a measure-based filter.

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

<minSubtotal> (Min Subtotal)

Specifies a boolean value that indicates whether to apply the 'min' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates that the 'min' aggregation function is applied in the subtotal for this field.

A value of off, 0, or false indicates another aggregation function is applied in the subtotal for this field.

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

<multipleItemSelectionAllowed> (Multiple Field Filters)

Specifies a boolean value that indicates whether the field can have multiple items selected in the page field.

A value of on, 1, or true indicates the PivotTable can have multiple items selected in the page field.

A value of off, 0, or false indicates the PivotTable cannot have multiple items selected in the page field. This attribute depends on the application support for selecting multiple items in page fields.

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

<name> (Field Name)

Specifies the name of the field.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

<nonAutoSortDefault> (Auto Sort)

Specifies a boolean value that indicates whether sort operation that will be applied to field should be AutoSort operation or simple data sort operation.

A value of on, 1, or true indicates that an AutoSort operation will be applied to the field.

A value of off, 0, or false indicates a simple data sort operation will be applied to the field.

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

<numFmtId> (Number Format Id)

Specifies the identifier of the number format to apply to this field. Number formats are written to the styles part. See the Styles section (§3.8) for more information on number formats.

Note: Formatting information provided by cell table and by PivotTable need not agree. If the two formats differ, the cell-level formatting takes precedence. If you change the layout the PivotTable, the PivotTable formatting will then take precedence.

The possible values for this attribute are defined by the ST_NumFmtId simple type (§3.18.49).

<outline> (Outline Items)

Specifies a boolean value that indicates whether the items in this field should be shown in Outline form.

A value of on, 1, or true indicates the items in this field will be shown in Outline form.

A value of off, 0, or false indicates the items in this field will not be shown in Outline form. This attribute depends on the application support for displaying items in Outline form.

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

<productSubtotal> (Product Subtotal)

Specifies a boolean value that indicates whether to apply 'product' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates that the 'product' aggregation function is applied in the subtotal for this field.

A value of off, 0, or false indicates another aggregation function is applied in the subtotal for this field.

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

<rankBy> (Auto Show Rank By)

Specifies the index of the data field by which AutoShow will rank.

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

<serverField> (Server-based Page Field)

Specifies a boolean value that indicates whether this is a server-based page field.

A value of on, 1, or true indicates this is a server-based page field.

A value of off, 0, or false indicates this is a local page field.

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

<showAll> (Show All Items)

Specifies a boolean value that indicates whether to show all items for this field.

A value of on, 1, or true indicates that all items be shown.

A value of off, 0, or false indicates items be shown according to user specified criteria.

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

<showDropDowns> (Show PivotField Header Drop Downs)

Specifies a boolean value that indicates whether to hide drop down buttons on PivotField headers. This attribute depends on the application implementation for filtering in the user interface.

A value of on, 1, or true indicates the application will display some mechanism for selecting and applying filters--for example, a dropdown menu--in the user interface.

A value of off, 0, or false indicates for mechanism for applying a filter will be displayed in the user interface.

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

<showPropAsCaption> (Show As Caption)

Specifies a boolean value that indicates whether to show the property as a member caption.

A value of on, 1, or true indicates the property will be shown as a member caption.

A value of off, 0, or false indicates the property will not be shown as a member caption.

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

<showPropCell> (Show Member Property in Cell)

Specifies a boolean value that indicates whether to show the member property value in a PivotTable cell.

A value of on, 1, or true indicates the property value will be shown in a PivotTable cell.

A value of off, 0, or false indicates the property value will not be shown in a PivotTable cell.

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

<showPropTip> (Show Member Property ToolTip)

Specifies a boolean value that indicates whether to show the member property value in a tooltip on the appropriate PivotTable cells.

A value of on, 1, or true indicates the property value will be shown in a tooltip in the user interface.

A value of off, 0, or false indicates the property will not be shown in a tooltip. This attribute depends on whether the application employs tooltips or similar mechanism in the user interface.

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

<sortType> (Auto Sort Type)

Specifies the type of sort that is applied to this field.

The possible values for this attribute are defined by the ST_FieldSortType simple type (§3.18.29).

<stdDevPSubtotal> (StdDevP Subtotal)

Specifies a boolean value that indicates whether to apply the 'stdDevP' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates that the 'stdDevP' aggregation function is applied in the subtotal for this field.

A value of off, 0, or false indicates another aggregation function is applied in the subtotal for this field.

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

<stdDevSubtotal> (StdDev Subtotal)

Specifies a boolean value that indicates whether to use 'stdDev' in the subtotal of this field.

A value of on, 1, or true indicates that the 'stdDev' aggregation function is applied in the subtotal for this field.

A value of off, 0, or false indicates another aggregation function is applied in the subtotal for this field.

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

<subtotalCaption> (Custom Subtotal Caption)

Specifies the custom text that is displayed for the subtotals label.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

<subtotalTop> (Subtotals At Top)

Specifies a boolean value that indicates whether to display subtotals at the top of the group. Applies only when Outline its true.

A value of on, 1, or true indicates a subtotal will be display at the top of the group.

A value of off, 0, or false indicates subtotal will not be displayed at the top of the group.

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

<sumSubtotal> (Sum Subtotal)

Specifies a boolean value that indicates whether apply the 'sum' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates the 'sum' aggregation function will be applied in the subtotal of this field.

A value of off, 0, or false indicates another aggregation function will be applied in the subtotal of this field.

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

<topAutoShow> (Top Auto Show)

Specifies a boolean value that indicates whether an AutoShow filter applied to this field is set to show the top ranked values.

A value of on, 1, or true indicates whether an AutoShow filter will show top values for this field.

A value of off, 0, or false indicates bottom ranked values will be shown.

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

<uniqueMemberProperty> (Unique Member Property)

Specifies the unique name of the member property to be used as a caption for the field and field items.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

<varPSubtotal> (VarP Subtotal)

Specifies a boolean value that indicates whether to apply the 'varP' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates the 'varP' aggregation function will be applied in the subtotal of this field.

A value of off, 0, or false indicates another aggregation function will be applied in the subtotal of this field.

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

<varSubtotal> (Variance Subtotal)

Specifies a boolean value that indicates whether to apply the 'variance' aggregation function in the subtotal of this field.

A value of on, 1, or true indicates the 'variance' aggregation function will be applied in the subtotal of this field.

A value of off, 0, or false indicates another aggregation function will be applied in the subtotal of this field.

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

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

<complexType name="CT_PivotField">
	<sequence>
	<element name="items" minOccurs="0" type="CT_Items"/>
	<element name="autoSortScope" minOccurs="0" type="CT_AutoSortScope"/>
	<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
	</sequence>
	<attribute name="name" type="ST_Xstring"/>
	<attribute name="axis" use="optional" type="ST_Axis"/>
	<attribute name="dataField" type="xsd:boolean" default="false"/>
	<attribute name="subtotalCaption" type="ST_Xstring"/>
	<attribute name="showDropDowns" type="xsd:boolean" default="true"/>
	<attribute name="hiddenLevel" type="xsd:boolean" default="false"/>
	<attribute name="uniqueMemberProperty" type="ST_Xstring"/>
	<attribute name="compact" type="xsd:boolean" default="true"/>
	<attribute name="allDrilled" type="xsd:boolean" default="false"/>
	<attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>
	<attribute name="outline" type="xsd:boolean" default="true"/>
	<attribute name="subtotalTop" type="xsd:boolean" default="true"/>
	<attribute name="dragToRow" type="xsd:boolean" default="true"/>
	<attribute name="dragToCol" type="xsd:boolean" default="true"/>
	<attribute name="multipleItemSelectionAllowed" type="xsd:boolean" default="false"/>
	<attribute name="dragToPage" type="xsd:boolean" default="true"/>
	<attribute name="dragToData" type="xsd:boolean" default="true"/>
	<attribute name="dragOff" type="xsd:boolean" default="true"/>
	<attribute name="showAll" type="xsd:boolean" default="true"/>
	<attribute name="insertBlankRow" type="xsd:boolean" default="false"/>
	<attribute name="serverField" type="xsd:boolean" default="false"/>
	<attribute name="insertPageBreak" type="xsd:boolean" default="false"/>
	<attribute name="autoShow" type="xsd:boolean" default="false"/>
	<attribute name="topAutoShow" type="xsd:boolean" default="true"/>
	<attribute name="hideNewItems" type="xsd:boolean" default="false"/>
	<attribute name="measureFilter" type="xsd:boolean" default="false"/>
	<attribute name="includeNewItemsInFilter" type="xsd:boolean" default="false"/>
	<attribute name="itemPageCount" type="xsd:unsignedInt" default="10"/>
	<attribute name="sortType" type="ST_FieldSortType" default="manual"/>
	<attribute name="dataSourceSort" type="xsd:boolean" use="optional"/>
	<attribute name="nonAutoSortDefault" type="xsd:boolean" default="false"/>
	<attribute name="rankBy" type="xsd:unsignedInt" use="optional"/>
	<attribute name="defaultSubtotal" type="xsd:boolean" default="true"/>
	<attribute name="sumSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="countASubtotal" type="xsd:boolean" default="false"/>
	<attribute name="avgSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="maxSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="minSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="productSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="countSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="stdDevSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="stdDevPSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="varSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="varPSubtotal" type="xsd:boolean" default="false"/>
	<attribute name="showPropCell" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="showPropTip" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="showPropAsCaption" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="defaultAttributeDrillState" type="xsd:boolean" use="optional" default="false"/>
</complexType>