aggr function

[sayalip]

HI Everyone,

it would be great if you suggest on below-

i have below data

Emp id	date	flag
1	01-01-2020	Y
2	01-01-2020	N
3	01-01-2020	Y
4	01-01-2020	Y
5	01-01-2020	Y
1	15-01-2020	N
2	16-01-2020	Y
3	20-01-2020	N

flag value says yes or no for employee who is coming for event. (if employee is coming for event then flag yes else no)

date is updated entry for employee if employee changes mind for attending event.

i want final list of employee who are coming for event.

[sunny_talwar · Accepted solution]

Try this

=-Sum(Aggr(FirstSortedValue(flag, -date) = 'Y', [Emp id]))

[sayalip]

thank you so much it works.