Mike, I have just put up an EXCEL 2007 file for you at:-

http://www.pierrefondes.com/

- item number 76 towards the top of my home page.

This gives you sales per employee.

If my comments have helped please hit Yes.

Thanks.




"Mike C" wrote:

I have 3 fields, Building, Employee, and Sales. I have about 3,000 records in
total.

I can run a simple pivot table to show by building which counts the
employees and sums the sales. This is great but I'd also like to show a
calculated field and and show much sales per employee. When I try to add a
calculated field to do this it gives me a divide by zero. I think it is
because the employees are text but I'm not sure.

Thanks in advance for any suggestions or ideas.
-Mike