Excel Magic Trick 1394

PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total


See how to use formulas to calculate “PivotTable Show Values As: Calculations:
(00:14) Introduction to unusual formulas for standard PivotTable Show Values As Calculations
(01:29) Total Revenue Formula for either Product or Manufacturer in single column. See the functions: SUMIFS, SUBSTITUTE, IF and ISBLANK.
(05:53) % Column Total Formula.
(06:26) % Parent Total Formula. See the functions: ISBLANK, MATCH and INDEX.
(13:30) % Parent Row Total Formula. See the functions: IF, OR and ISBLANK.
(16:04) Summary


Download “Excel Magic Trick 1391-1400” Excel-Magic-Trick-1391-1400.zip – Downloaded 49 times – 3 MB

Be the first to comment

Leave a Reply