Set analysis - Find Current Location of employee Based on Current Designation

[pratham39]

Hi,

I have below table on frontend ,

the Green one is current location of employee based on max number of Designation No which is 13,

So basically in Current Location Column that value should come (Allahabad_W_EC)

Please help me to write set analysis for Current Location....

Thanks

#SetAnalysis

[BrunPierre]

As below with set analysis

Only({$<[Designation No]={"$(=Max([Designation No]))"}>} [Location Area])

[pratham39]

Hi,

Thanks for reply,

Your solution is working perfectly fine for any single employee ,

but in overall table for all employees it is only showing Max DesignationNo Location 

The Red one in below table should show location Mumbai but as it is taking max ID - 13 as per your expression 

it won't show Mumbai 

Please help

Thanks

[BrunPierre · Accepted solution]

Try this

Aggr(FirstSortedValue([Location Area], -[Designation No]), [Employee No])

[pratham39]

It worked!

Thanks