Aggregate object data

  1. On the Data Source tab, expand the tree view to locate the object.
  2. Right-click the object, then select Properties.
  3. Select Aggregation in the Views pane.
  4. Move aggregate columns to the lower pane.
  5. Use Auto to aggregate on all the natural key identifiers.
    Note: 

    These must be included in composers as they form the foundation for the relations set up columns and non-numeric columns. All those columns are selected for the aggregation. The auto-aggregation sets the aggregation function sum for all the other columns.