Get last 2 records

[#1]

Hello,

I have a table where i have to get the last 2 records where the amounthave changed:

Start Date	Amount
4/30/2012 0:00	2066500
4/30/2011 0:00	1767500
6/30/2010 0:00	3000
6/30/2010 0:00	43000
4/30/2010 0:00	25000
11/30/2008 0:00	8000
11/30/2008 0:00	238000
10/31/2008 0:00	18000
2/29/2008 0:00	600
2/29/2008 0:00	118000

can this be done without having to create a special table for this report from the script?

any suggestion?

[rwunderlich]

How about:

=subfield(concat(DISTINCT Amount, ';', StartDate), ';', count(DISTINCT Amount))

for the last record.

=subfield(concat(DISTINCT Amount, ';', StartDate), ';', count(DISTINCT Amount)-1)

and the next to last record.

-Rob

http://robwunderlich.com