[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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>