Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Aggr(FirstSortedValue([Location Area], -[Designation No]), [Employee No])
As below with set analysis
Only({$<[Designation No]={"$(=Max([Designation No]))"}>} [Location Area])
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
Try this
Aggr(FirstSortedValue([Location Area], -[Designation No]), [Employee No])
It worked!
Thanks