I have a spread sheet for tracking defects. When I make it a pivot chart, I am having a problem. Example: I have unit # 123. This unit may have 50 different defects that are each listed in 50 different rows. Bob is responsible for unit # 123. This goes on for many different units and many different responsible people. I am trying to find out averages per unit, but the pivot does not breakdown the units by individule numbers. So unit # 123 it counts fifty times, I want it to see that all fifty entries are for 1 unit. So I can tell that bob was judged on 1 unit and maybe someone else was judged on 2 units. So if I say average defects for bob, it can break down that bob worked on 1 unit (not fifty) for an average of 10 defects per unit and not an average of .00001 for the average of each row.