[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

item (PivotTable Field Item)

Represents a single item in PivotTable field.

[Example:

<sh:item x="66"/>

end example]

Parent Elements

items3.10.1.46)

 

Attributes

Description

c (Child Items)

Specifies a boolean value that indicates whether the approximate number of child items for this item is greater than zero.

 

A value of on, 1, or true indicates the approximate number of child items for this item is greater than zero.

 

A value of off, 0, or false indicates the approximate number of child items for this item is zero.

 

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

d (Expanded)

Specifies a boolean value that indicates whether this item has been expanded in the PivotTable view.

 

A value of on, 1, or true indicates this item has been expanded.

 

A value of off, 0, or false indicates this item is collapsed.

 

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

e (Drill Across Attributes)

Specifies a boolean value that indicates whether attribute hierarchies nested next to each other on a PivotTable row or column will offer drilling "across" each other or not. For example, if the application offers drill across for attribute hierarchies and not for user hierarchies, this attribute would only be written when two attribute hierarchies are placed next to each other on an axis.

 

A value of on, 1, or true indicates there is a drill across attribute hierarchies positioned next to each other on a pivot axis.

 

A value of off, 0, or false indicates there is not drill across attribute hierarchies.

 

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

f (Calculated Member)

Specifies a boolean value that indicates whether this item is a calculated member.

 

A value of on, 1, or true indicates this item is a calculated member.

 

A value of off, 0, or false indicates this item is not calculated.

 

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

h (Hidden)

Specifies a boolean value that indicates whether the item is hidden.

 

A value of on, 1, or true indicates item is hidden.

 

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

m (Missing)

Specifies a boolean value that indicate whether the item has a missing value.

 

A value of on, 1, or true indicates the item value is missing. The application should still retain the item settings in case the item reappears during a later refresh.

 

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

n (Item User Caption)

Specifies the user caption of the item.

 

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

s (Character)

Specifies a boolean value that indicates whether the item has a character value.

 

A value of on, 1, or true indicates the item has a string/character value.

 

A value of off, 0, or false indicates item the item has a value of a different type.

 

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

sd (Hide Details)

Specifies a boolean value that indicates whether the details are hidden for this item.

 

A value of on, 1, or true indicates item details are hidden.

 

A value of off, 0, or false indicates item details are shown.

 

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

t (Item Type)

Specifies the type of this item. A value of 'default' indicates the subtotal or total item.

 

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

x (Item Index)

Specifies the item index in pivotFields collection in the PivotCache. Applies only non-OLAP PivotTables.

 

In the following example, "Product Category" and "Product Subcategory" are on the row axis of the PivotTable, in that order.

 

<rowFields count="2">

<field x="7"/>

<x="8"/>

</rowFieldsfield >

 

 

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_Item">

   <attribute name="n" type="ST_Xstring"/>

   <attribute name="t" type="ST_ItemType" default="data"/>

   <attribute name="h" type="xsd:boolean" default="false"/>

   <attribute name="s" type="xsd:boolean" default="false"/>

   <attribute name="sd" type="xsd:boolean" default="true"/>

   <attribute name="f" type="xsd:boolean" default="false"/>

   <attribute name="m" type="xsd:boolean" default="false"/>

   <attribute name="c" type="xsd:boolean" default="false"/>

   <attribute name="x" type="xsd:unsignedInt" use="optional"/>

   <attribute name="d" type="xsd:boolean" default="false"/>

   <attribute name="e" type="xsd:boolean" default="true"/>

</complexType>