In E2: =IF(A2="","",SUMPRODUCT((A$2:A2=A2)*(D$2:D2=D2)))

Try changing the formula in E2 to:
=IF(A2="","",SUMPRODUCT((A$2:A2=A2)*(D$2:D2=D2),C$ 2:C2))
Copy down. Refresh the pivot.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"lesg46" wrote:
Hi Max,
This almost works!
Heres the result I get with your formulas.

date Product qty Cust. Int Items
12/01/2007 Apple 1 6057 1 1
12/01/2007 Apple 2 6058 1
12/01/2007 Banana 1 6058 2 2
12/01/2007 Apple 1 6059 1
12/01/2007 Banana 1 6059 2
12/01/2007 Carrot 2 6059 3 3


However it doesn't take into account the quantity of each item that the
customer may have bought, just the number of times the customer number
appears on a particular day. Somehow Column C (Qty) needs to come into play
too. So that for customer 6058 I get the result of 3, and for 6059 I get 4.

Im now way out of my depth, so if you can help further Id be most grateful.

Thanks again,
Lesley