Good day,

I am wanting to create an embedded formula into a pivot table,

I want to calculate the a percentage based on the scores of 4 and 5 / the sum,

(score[4] + score[5]) / Score

How so I tell the formula to select the scores of 4 or the scores of 5?

For Agent X, (40 + 70) / 172 = 64%

Score
Agent 1 2 3 4 5
X 36 11 15 40 70
Y 10 9 10 12 69
Z 58 10 9 19 44