Average in a Pivot Table

[time conversion]

I have a report that is looking for average times for surgical cases.

SURGEON PROCEDURE TIME AVERAGE

Dr Smith Appendix 92 min 79.25 min
85 min
75 min
65 min

Dr. Jones Gall Bladder 62 min 66.22 min
58 min
69 min
91 min
51 min
Would anyone know how I could find the average for thousands of these
types of procedures?? Ihave all the data....Surgeon/Procedure/Case
Time......but I can't figure out how to get the averages for each surgeon per
procedure.

 

[Dave Peterson]

I would change the layout of the data.

I'd make sure that each row of the data had all the information that pertained
to that record.

SURGEON PROCEDURE TIME (in Min)
Dr Smith Appendix 92
Dr Smith Appendix 85
Dr Smith Appendix 75
Dr Smith Appendix 65
Dr. Jones Gall Bladder 62
Dr. Jones Gall Bladder 58
Dr. Jones Gall Bladder 69
Dr. Jones Gall Bladder 91
Dr. Jones Gall Bladder 51

(no empty rows and no missing information.)

Then I could use data|subtotal or data|pivottable to get very nice and quick
summaries.