SUMBY

Sums a list of numbers, partitioned by the unique values of a separate column

SUMBY( column, partition column )

Sums the values within a column when grouped by unique values within a partition column

SUMBY() is a window function, which performs SUM() except partitioned by the unique values of a separate column.

Arguments

Arguments	Description
column	Column to sum
partition column	Column containing unique values

Output

Outputs a sum of values when grouped by partition column

Example