Aggregations Element (List)

Last modified: March 09, 2015

Applies to: SharePoint Foundation 2010

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

  Value = "Text">
  <FieldRef />




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

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">