In my pivot table on the "Rep Level" tab, I need my E column on my pivot table to show an overall percentage of the total sum of exceptions (column D) divided by the total sum of estimates (column C) for each person. Example: cell E4 needs to show the percentage of D4/C4. The answer should should come to 19.52%. What value field settings or pivot table setup do I need to change to get it to calculate the right result?
Bookmarks