display most recent event

[#1]

i'm trying to select the most recent event based on a date for each customer.

dataset:

customer	event	date
1	sign	1/2/12
1	apply	1/3/12
1	accept	1/5/12
1	renew	1/7/12
2	sign	2/7/12
2	apply	2/3/12
2	accept	3/12/12
2	deny	1/4/12
3	apply	2/1/12
3	renew	3/12/12

result:

customer	event	date
1	renew	1/7/12
2	accept	3/12/12
3	renew	3/12/12

however, if i select an event (i.e. sign), i want to see the 'signs' so i don't want to eliminate the other values, just display the most recent if no events are selected.

thanks!

[MayilVahanan]

HI

Try like this

=FirstSortedValue(Customer,-date)

Hope it helps