Prev: Excel 2007 - Autocomplete Alpha List
Next: In new Office 2007 EXCEL, can more the 8 IF statements be used?
From: Mike C on 24 Mar 2010 08:59
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
From: trip_to_tokyo on 24 Mar 2010 11:26
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
From: Roger Govier on 24 Mar 2010 15:50
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.
--
Regards
Roger Govier

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
 | 
Pages: 1
Prev: Excel 2007 - Autocomplete Alpha List
Next: In new Office 2007 EXCEL, can more the 8 IF statements be used?