Select value related on another field

[#1]

Source Data

Name ID	Policy ID	Province
1	111	BKK
1	112	CM
1	113	LP
2	211	BKK
2	212	CM
2	213	KKC
2	214	PY

Require Output

Name ID	Max Policy ID	Province by Max Policy ID
1	113	LP
2	214	PY

How about Set Analysis for Province by Max Policy ID Field ?

[ramoncova06]

you can get it by using the firstsorted value

=FIRSTSORTEDVALUE (Province , – aggr(max(Policy ID),Province) )

[MarcoWedel]

Hi,

one solution could be:

=FirstSortedValue(Province, -[Policy ID])

hope this helps

regards

Marco