[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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>