Amount by Min Date and Country

wunderch — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have the following table:

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

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

Re: Amount by Min Date and Country

Clever_Anjos — Wed, 26 Feb 2014 14:43:59 GMT

Straight Table

One dimension: Country

Two Expressions:

1) Min(Date)

2) FirstSortedValue(Amount,-Date)