Aggregate Transform provides a way to group data by column(s) and apply aggregation functions on them.
In this recipe we will fetch each Sales Person according to the start and end date of sales and the sum of their sales quota by resorting to an Aggregate Transform.
AdventureWorks2012sample database. Set the data access mode to SQL Command and enter the following T-SQL code in the SQL Command field:
SELECT SLHST.QuotaDate, SLHST.SalesQuota, PER.FirstName, PER.LastName FROM Sales.SalesPersonQuotaHistory SLHST INNER ...