Amount by Min Date and Country

[wunderch]

Hi,

I have the following table:

Country	Date	Amount
Germany	25.10.2013	100
Germany	02.10.2013	500
USA	04.05.2013	50
USA	10.05.2013	80
Greece	08.03.2013	20
Greece	10.03.2013	60

Now I only want the Amount from the first date by Month and Country, so that the result is:

Country	Date	Amount
Germany	02.10.2013	500
USA	04.05.2013	50
Greece	08.03.2013	20

I can't do it in the script with "First" and "group by", because I need all rows of the table for other calculations.

Any ideas?

Thanks

Chris

[Clever_Anjos · Accepted solution]

Straight Table

One dimension: Country

Two Expressions:

1) Min(Date)

2) FirstSortedValue(Amount,-Date)