This is probably a stupid question, but please bear with me. I have a table
that lists sales data, something like this:

date invoice customer amount
1/4/04 1 X 100
1/5/04 2 X 200
1/5/04 3 Y 100

All I want to do is to get a table that gives me the sum totals for each
customer or for a certain date, etc. I have tried Pivot tables, but for some
reason the pivot tables give me the count of entries for each customer, but
not the sum of the purchases. Is there a simple way of doing this?

mike