PIVOTBY

PIVOTBY(row_fields ,col_fields ,values ,function [,field_headers] [,row_total_depth] [,row_sort_order] [,col_total_depth] [,col_sort_order] [,filter_array])

Returns the grouping of your data along two axis and aggregates the associated values.

row_fields	A column-oriented array or range that contains the values which are used to group rows and generate row headers.
col_fields	A column-oriented array or range that contains the values which are used to group columns and generate column headers.
values	A column-oriented array or range of the data to aggregate.
function	A lambda function or eta reduced lambda (SUM, AVERAGE, COUNT, etc) that defines how to aggregate the values.
field_headers	A number that specifies whether the row_fields, col_fields and values have headers and whether field headers should be returned in the results.
row_total_depth	(Optional) Determines whether the row headers should contain totals.
row_sort_order	(Optional) A number indicating how rows should be sorted.
col_total_depth	(Optional) Determines whether the column headers should contain totals.
col_sort_order	(Optional) A number indicating how rows should be sorted.
filter_array	(Optional) A column-oriented 1D array of Booleans that indicate whether the corresponding row of data should be considered.

REMARKS

* This function was added in Microsoft 365.
* This function can create a Dynamic Array Formula.
* You can use the GETPIVOTDATA function to return the data obtained from a pivot table.
* You can use the GROUPBY function to return the grouping of your data along one axis and aggregates the associated values.
* This function was first released in December 2023.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	??