<ST_ItemType> (PivotItem Type)

This simple type defines the type for a pivotItem.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

<avg> (Average)

Indicates the pivot item represents an "average" aggregate function.

<blank> (Blank Pivot Item)

Indicates the pivot item represents a blank line.

<count> (Count)

Indicates the pivot item represents custom the "count" aggregate."

<countA> (CountA)

Indicates the pivot item represents the "count numbers" aggregate function.

<data> (Data)

Indicate the pivot item represents data.

<default> (Default)

Indicates the pivot item represents the default type for this PivotTable. The default pivot item type is the "total" aggregate function.

<grand> (Grand Total Item)

Indicates the pivot items represents the grand total line.

<max> (Max)

Indicates the pivot item represents the "maximum" aggregate function.

<min> (Min)

Indicates the pivot item represents the "minimum" aggregate function.

<product> (Product)

Indicates the pivot item represents the "product" function.

<stdDev> (stdDev)

Indicates the pivot item represents the "standard deviation" aggregate function.

<stdDevP> (StdDevP)

Indicates the pivot item represents the "standard deviation population" aggregate function.

<sum> (Sum)

Indicates the pivot item represents the "sum" aggregate value.

<var> (Var)

Indicates the pivot item represents the "variance" aggregate value.

<varP> (VarP)

Indicates the pivot item represents the "variance population" aggregate value.

Referenced By

<i@t> (§3.10.1.44); <item@t> (§3.10.1.45)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_ItemType">
	<restriction base="xsd:string">
	<enumeration value="data"/>
	<enumeration value="default"/>
	<enumeration value="sum"/>
	<enumeration value="countA"/>
	<enumeration value="avg"/>
	<enumeration value="max"/>
	<enumeration value="min"/>
	<enumeration value="product"/>
	<enumeration value="count"/>
	<enumeration value="stdDev"/>
	<enumeration value="stdDevP"/>
	<enumeration value="var"/>
	<enumeration value="varP"/>
	<enumeration value="grand"/>
	<enumeration value="blank"/>
	</restriction>
</simpleType>