<ST_ShowDataAs> (Show Data As)

This simple type defines the data formats for a field in the PivotTable.

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

<difference> (Difference)

Indicates the field is shown as the "difference from" a value.

<index> (Index)

Indicates the field is shown as the "index.

<normal> (Normal Data Type)

Indicates that the field is shown as its normal data type.

<percent> (Percentage Of)

Indicates the field is show as the "percentage of

<percentDiff> (Percentage Difference)

Indicates the field is shown as the "percentage difference from" a value.

<percentOfCol> (Percent of Column)

Indicates the field is shown as the percentage of column.

<percentOfRow> (Percentage of Row)

Indicates the field is shown as the percentage of row

<percentOfTotal> (Percentage of Total)

Indicates the field is shown as percentage of total.

<runTotal> (Running Total)

Indicates the field is shown as running total in the table.

Referenced By

<dataField@showDataAs> (§3.10.1.22)

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

<simpleType name="ST_ShowDataAs">
	<restriction base="xsd:string">
	<enumeration value="normal"/>
	<enumeration value="difference"/>
	<enumeration value="percent"/>
	<enumeration value="percentDiff"/>
	<enumeration value="runTotal"/>
	<enumeration value="percentOfRow"/>
	<enumeration value="percentOfCol"/>
	<enumeration value="percentOfTotal"/>
	<enumeration value="index"/>
	</restriction>
</simpleType>