Can anyone help me.

I have used pivot tables a bit, but I am trying to get to grips with
them a bit more and I have hit a stumbling block.

I have a set of data which has two columns, one for reference which is
a unique job number, one for customer where numourous jobs can be for
each customer and a total profit for each job.

The pivot table I have built shows the total profit for each customer
and the number of jobs (using a count on reference) per customer.

What I want to do is enter a calculated field which divides the total
profit for the customer by the number of jobs to give me an average job
profit for each customer.

I have tried =Sum('Gross Profit')/Count('Job Ref') but that just
returns the gross profit by customer number.

Can anyone help?

Thanks

Simon


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=548926