Aggregating Grouped Data

A very common requirement when grouping data is to perform some kind of aggregation, such as summing or counting, of the grouped values. The DsAggregate Column element, when used as a child of DsGroup, gives you the ability to generate this summary data for the grouped columns in the data.

In the example above, the DsGroup element's Group Column has been set to ShipCity. A DsAggregate Column element has been added as a child element and configured to Sum the values found in the grouped Freight columns.

And the results are shown above.

When grouping is applied and aggregation is used, only values from the columns named in the Group Column and the Aggregate Column attributes are returned to the datalayer.