Can GROUPBY replicate calculated fields of a PivotTable in Microsoft 365?
Автор: Practical Spreadsheet Solutions
Загружено: 2025-10-15
Просмотров: 125
Can function GROUPBY replicate the functionality of calculated fields of a PivotTable? The functions GROUPBY and PIVOTBY can group and aggregate data, so that the user can get the benefits of a PivotTable without actually having to use one. As an additional bonus, these functions get updated dynamically when the source data changes. But can these functions also replicate the three key features of calculated fields, namely custom aggregation, custom naming, and performing calculations with multiple fields (e.g. calculating total of two fields)? This video will answer this question using function GROUPBY. The third feature will be especially tricky to replicate, because of how this function works.
00:00 Introduction
01:06 Preparation
03:20 Aggregation rule of function GROUPBY
04:43 Custom aggregation function
06:43 Custom name
07:55 Trick for adding two columns inside custom Lambda function
Here is the link to the file with the formulas from the video:
https://docs.google.com/spreadsheets/...
The thumbnail of this video includes AI-generated images made using Canva.
For more contents like this, please subscribe to my channel.
#MsExcel #ExcelTips
Screenshots used with permission from Microsoft.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
