PIVOTBY
Creates a pivoted summary of your data using a grouping function to aggregate values
Syntax
PIVOTBY(row_fields, col_fields, values, function, [field_headers], [row_total_depth], [row_sort_order], [col_total_depth], [col_sort_order], [filter_array])
Parameters
- row_fields: Required. A column-oriented array or range to group by on rows
- col_fields: Required. A column-oriented array or range to group by on columns
- values: Required. A column-oriented array or range of data to aggregate
- function: Required. A LAMBDA function to aggregate values
- field_headers: Optional. A number indicating whether data has headers
- row_total_depth: Optional. Determines whether row totals are shown
- row_sort_order: Optional. A number indicating how to sort row results
- col_total_depth: Optional. Determines whether column totals are shown
- col_sort_order: Optional. A number indicating how to sort column results
- filter_array: Optional. A 1D array of TRUE/FALSE to filter data
Example
=PIVOTBY(A2:A20, B2:B20, C2:C20, SUM)