GROUPBY / PIVOTBY

Namespaced Aliases

GB_PIVOTBY

Collision-resistant alias for PIVOTBY.

Syntax

=GB_PIVOTBY(row_fields, column_fields, values, function_name, [field_headers], [row_total_depth], [row_sort_order], [column_total_depth], [column_sort_order], [filter_array])

Parameters

Namerow_fields
Typerange
DescriptionOne or more columns used for row grouping.
Namecolumn_fields
Typerange
DescriptionOne or more columns used to create pivot columns.
Namevalues
Typerange
DescriptionOne or more columns containing values to aggregate.
Namefunction_name
Typetext or range
DescriptionAggregation name such as "SUM" or "AVERAGE".

Returns

The same spilled pivot table as PIVOTBY.

Example

=GB_PIVOTBY(A1:A6, B1:B6, C1:C6, "SUM", TRUE)

Result: Q1/Q2 revenue columns by region

Notes

GB_PIVOTBY accepts the same optional arguments as PIVOTBY.

Use the alias when you want formulas with a family prefix.

    xs