Download Files:

Start File and Finished File:

https://excelisfun.net/files/EMT1393-94.xlsx

https://excelisfun.net/files/EMT1394%20Part%202.xlsx

See how to create a formula to calculate % of Parent Total using INDEX and MATCH functions with wildcards. This formula comes from Bill Szysz at YouTube.

Reference Video:
Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total
Excel Magic Trick 1393: PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total
Excel Magic Trick 1395: DAX Formulas for % Grand Total, % Column Total, % Parent Total