I have an issue where we aggregate data and balances on records (loans) over various points in time, leaving us with multiple records over different periods of time. I'm trying to aggregate the values of the most recent iteration of each unique ID. I have attached a sample (including the required end result). I'm assuming I'm looking for some combination of a lookup function and... something else? I've done a bit of research and found some similar posts but nothing that I could tailor to fit my use case.
Any help that can be provided would be greatly appreciated. Thanks!
-Dan
2 answers
Hi, Daniel
Please see my solution below
Hope this could help
ZZ
