Create dynamic in-pivot formulas (e.g. Profit Margin = Profit / Revenue) and calculate '% of Grand Total' in 2 clicks.
“Calculated Fields & Show Values As (% of Column, Running Total)” is part of Level 2: Intermediate Excel — Lookups, Analytics & Pivot MIS. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.