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