% of total & % of parent in GROUPBY PIVOTBY in Excel. NEW in 2024

GROUPBY & PIVOTBY are new awesome Excel functions which in many ways replace PivotTables, in this video (part of a series of videos I have on them), I showcase how to work with % of totals in GROUPBY and PIVOTBY, it's not so intuitive for % of parent totals, % of row totals so I cover it in this video.

Download the workbook here (labeled GROUPBY PIVOTBY complete guide): https://www.xlconsulting-asia.com/you...
GROUPBY / PIVOTBY with multiple columns non consecutive etc.    • Use GROUPBY with multiple fields. Row...  
GROUPBY / PIVOTBY basics:    • GROUPBY and PIVOTBY introduction. Exc...  

00:00 Introduction
00:26 % of total
01:03 PivotTable % of total
02:27 % of parent
05:16 % of row
08:19 Avoiding DIV 0 errors