Edit

Share via

Aggregations element (List)

  • Article

Applies to: SharePoint 2016 | SharePoint Foundation 2013 | SharePoint Online | SharePoint Server 2013

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>

Elements and attributes

The following sections describe attributes, child elements, and parent elements.

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

Parent elements

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>