Using pivot table sum values?

[patchesohouli]

Hi,

I have a pivot table that consists of:
Employee Name
Total test score
Total possible test score

The pivot table is summing the employee's total test score for me, as the employee may have 10 different test scores and entered many times. I just want a simple calculation that will divide the “Total test score” field I created with the pivot table / Total possible test score.

How does one use a pivot table sum field values in a calculation? Thanks

[peterrc]

Please upload your file and I, and others will try to help.

peterrc