pivot chart

[carson33]

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.

 

[PaddyD]

Hi - you need to relate your problem to the layout of your data to get any traction

 

[carson33]

What? keep in mind, i'm not real smart.

 

[PaddyD]

How's your data set up?

 

[carson33]

sorry so slow, down with the flu

how can i show you my spreadsheet? I can try to describe it. Across the top I have the following;

Date,Week ,Uni#,Inspector,Department,Groupleader,Area,Problem,Defects

Then under each is the info I need. The problem is if groupleader 1 has had 5 units inspected and groupleader 2 has only had 2 units inspected, obviously groupleader 1 will have far more defects. Not sure how to average it out to average defects per unit.

 

[PaddyD]

"how can i show you my spreadsheet?"

http://www.mrexcel.com/board2/viewtopic.php?t=92622

post up a representative snapshot (say 15 rows & 5 or 6 columns) & take us through a worked example of the result you're trying to achieve