I am trying to figure out how to do a calculation on two fields in a pivot table. The struggle I'm having is that these two fields are already calculated as averages. I want to create a calculated field in column D that will express the value in B as a percentage of the value in C. So, in row 6 for Stephen Curry, the value in D would be 5.84% (119.25/112.66).
Thoughts?
Excel 2010
<tbody>
</tbody>
<tbody>
</tbody>
Thoughts?
Excel 2010
Row\Col | A | B | C |
---|---|---|---|
4 | |||
5 | Row Labels | Average of Today's Line | Average of Implied |
6 | Stephen Curry | 119.25 | 112.66 |
7 | Russell Westbrook | 115.25 | 109.44 |
8 | Norris Cole | 112.25 | 102.67 |
9 | Jrue Holiday | 112.25 | 102.67 |
10 | Tony Parker | 110.00 | 103.73 |
11 | Isaiah Thomas | 108.25 | 104.20 |
12 | Marcus Smart | 108.25 | 104.20 |
13 | Ricky Rubio | 107.25 | 100.19 |
14 | Mike Conley | 106.75 | 98.58 |
15 | Damian Lillard | 106.00 | 101.62 |
16 | Shelvin Mack | 104.50 | 102.81 |
17 | Patrick Beverley | 104.00 | 105.63 |
18 | Goran Dragic | 103.25 | 98.06 |
19 | E'Twaun Moore | 102.50 | 101.63 |
20 | Aaron Brooks | 102.50 | 101.33 |
21 | Michael Carter-Williams | 102.00 | 98.36 |
22 | Reggie Jackson | 100.50 | 100.71 |
23 | Archie Goodwin | 100.25 | 101.39 |
24 | Ronnie Price | 100.25 | 101.45 |
25 | Phil Pressey | 100.25 | 99.50 |
26 | Donald Sloan | 93.00 | 96.72 |
<tbody>
</tbody>
Sheet: PaceUp |
<tbody>
</tbody>