load Amount from resident for min(Date)

[#1]

From a resident Donor Transaction table, I'm building a stats table (e.g. first gift date, last gift date, largest gift amount, etc.) by Donor. For the first gift date for each Donor, I'd like to also get the Amount associated with the first gift date. Without joining the two tables, is there a way to sum Amount for the min(Date)?

Thanks,

Kevin

[vgutkovsky]

Kevin,

You can do it this way: firstsortedvalue(amount,date). Would that work or do you have multiple amounts per date?

Regards,

[#3]

Will most likely have multiple amounts per date in the case where the gift was split across multiple Designations.

Kevin

[vgutkovsky]

I think it depends on what dimensions you have in your chart. If you display the first gift date, then it can probably be a simple sum. Otherwise, you could do something like the following:

firstsortedvalue(
 aggr(sum(amount),donor,date)
 ,date
)

Regards,