Column A Column B Column C Column D Parent-1 600 460 140 30.43% Child-1 100 85 15 17.65% Child-2 200 150 50 33.33% Child-3 300 225 75 33.33% Value currently displayed in Column D is 84.31% , which is the sum of 17.65% + 33.33% +33.33% = 84.31%)