Expression

[#1]

Hi,

Can someone please help me with this requirement.

ID       No       Payment

10000     2         4000
10000     3         500
10000     4         50
10000     7         5000

I want to display Payment as 4000 for ID = 10000, since 3 is the min(Num).
How can I do this at expression level.

Thanks in advance.

Regards,

Adi

[sunny_talwar]

Try this expression with ID as your Dimension:

=Avg(If(Aggr(Min(No), ID) = No, Payment))

[maxgro]

FirstSortedValue(Payment, No)

[#4]

Thank u Massimo!!