Aggregations Element (View)

  • Article

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Contains field references for totals columns or calculated columns — in other words, for fields to which a function is applied.

<Aggregations
  Value = "Text">
  <FieldRef />
  ...
</Aggregations>

Attributes

Attribute

Description

Value

Optional Text. Set On to specify that total rows are enabled for the datasheet view; otherwise, do not specify this attribute.

Child Elements

FieldRef

Parent Elements

View

Occurrences

Minimum: 0

Maximum: 1

Example

The following example uses the Aggregations element to contain references for a totals column and a calculated column in a datasheet view. The first reference specifies that the Count function is applied to the Title column; the second reference specifies that the Sum function is applied to the Number column.

<View>
   ...
   <Aggregations Value="On">
      <FieldRef Name="Title" Type="Count">
      <FieldRef Name="Number" Type="Sum">
   </Aggregations>
</View>