Pivot Table - Calculated Field

[Mike C]

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

 

[trip_to_tokyo]

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.

 

[Roger Govier]

Hi Mike

If you drag Employee to the row labels, followed by Building to the Row
labels and Sales to the Values area, then you will get the analysis you
want.