<ST_GroupBy> (Values Group By)

This simple type defines types of data grouping that can be performed on a 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

<days> (Days)

Indicates a grouping on "days" for date values.

<hours> (Hours)

Indicates a grouping on "hours" for date values.

<minutes> (Minutes)

Indicates a grouping on "minutes" for date values.

<months> (Months)

Indicates a grouping on "months" for date values.

<quarters> (Quarters)

Indicates a grouping on "quarters" for date values.

<range> (Group By Numeric Ranges)

Indicates a grouping by numeric ranges for numeric values.

<seconds> (Seconds)

Indicates a grouping on "seconds" for date values.

<years> (Years)

Indicates a grouping on "years" for date values.

Referenced By

<rangePr@groupBy> (§3.10.1.78)

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

<simpleType name="ST_GroupBy">
	<restriction base="xsd:string">
	<enumeration value="range"/>
	<enumeration value="seconds"/>
	<enumeration value="minutes"/>
	<enumeration value="hours"/>
	<enumeration value="days"/>
	<enumeration value="months"/>
	<enumeration value="quarters"/>
	<enumeration value="years"/>
	</restriction>
</simpleType>