Sum of maximal date

[#1]

Hello. I have data like that:

customer, date, amount

1 1.11.2009 10

1 1.11.2009 10

1 3.11.2009 10

1 3.11.2009 20

2 3.11.2009 20

3 4.11.2009 40

I need make streight table and find sum of amount of last date for every customer.

customer, last date, amount

1 3.11.2009 30

2 3.11.2009 20

3 4.11.2009 40

Any idea?

[#2]

LOAD customer as customer1, max(date) as date1

RESIDENT table1

GROUP BY customer;

LEFT JOIN

LOAD customer as customer1, date as date1, sum(amount) as amount1

RESIDENT table1

GROUP BY customer, date;