Aggregation
When the source data is at a greater level of granularity than what is desired, you can use the Aggregation function to apply Sum, Min, Max, Ave, or Count to numeric/date fields grouped by the Selected Aggregation Columns.
When the source data is at a greater level of granularity than what is desired, you can use the Aggregation function to apply Sum, Min, Max, Ave, or Count to numeric/date fields grouped by the Selected Aggregation Columns.