Aggregations element (List)

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.

  Value = "Text">
  <FieldRef />

Elements and attributes

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


Attribute Description
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


  • Minimum: 0
  • Maximum: 1


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.

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