Sorry - I'm asking for help again!

Using Excel 2002 I have a sheet with many thousands of rows of data and I'm
trying to use pivot tables to analyse my data as follows:

Heres a sample of my data

Date Product Qty Customer
01/09/2007 Apple 1 2317
01/09/2007 Banana 1 2317
01/09/2007 Carrot 1 2317
01/09/2007 Apple 1 2324
01/09/2007 Apple 1 2326
01/10/2007 Apple 1 2352
01/10/2007 Banana 1 2352
01/10/2007 Apple 1 2354
01/10/2007 Apple 2 2365
01/10/2007 Carrot 1 2367
01/10/2007 Apple 1 2370
01/10/2007 Apple 1 2382
01/10/2007 Banana 1 2382
01/10/2007 Apple 1 2382
01/10/2007 Apple 1 2383
01/10/2007 Carrot 1 2383
01/10/2007 Apple 1 2385
01/10/2007 Apple 1 2386
01/10/2007 Carrot 2 2386

Heres my pivot table
Sum of Qty
Date Customer Total
01/09/07 2317 3
2324 1
2326 1
01/09/07 Total 5
01/10/07 2352 2
2354 1
2365 2
2367 1
2370 1
2382 3
2383 2
2385 1
2386 3
01/10/07 Total 16
Grand Total 21

What Im trying to achieve is a daily count of number of items purchased. I
don't care about who bought what item.

i.e.
1 item 2 items 3 items
1/9/2007 2 1
1/10/2007 4 3 2

Can this be done using pivot tables, or am I barking up the wrong tree? I
had thought I might need to create another pivot table based on my original
one, however I cant analyse by the results in the €˜total column.

As always, all help very gratefully received. My Excel knowledge is vastly
improved thanks to this forum, but Ive obviously still got a way to go!

Sorry it's such a lengthy question.

Many thanks

Les