Summary
This video introduces the GROUPBY and PIVOTBY functions to extended the Group Filter Aggregate Method.
Tab in example file: Expanding FILTER
This video introduces two functions GROUPBY and PIVOTBY.
GROUPBY – Creates a summary of data which displays unique grouping along one axis and an aggregation of values using a function argument.
PIVOTBY – Creates a summary of data which displays unique grouping along two axis and an aggregation of values using a function argument.
These functions apply the Group Filter Aggregate Method in a single function.
Both functions have the filter_array argument which is the same as the include argument in FILTER.