Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As you dont have date-timestamp for sorting and figuring out most current record, i used recno to fetch the most current record assuming the last record in the table is the most recent entered record. you can do like below:
//Backend Solution
Data:
LOAD *, recno() as sno inline [
Employee_id, current
123, 48
123, 0
123, 1
];
left join(Data)
LOAD Employee_id,
Max(current) as Best,
FirstSortedValue(current, -sno) as most_current
RESIDENT Data
GROUP BY Employee_id;
//Front End Solution:
Dim: Employee_ID
Measure1: Best = Max(total <Employee_id> current)
Measure2: current = only({$<sno={"$(=max(total <Employee_id> sno))"}>}current)
the most current record table is unaffected by any selections like you mentioned.
on the UI, there are couple other methods, if this works for you proceed with it.
it should wor but am not sure how yur real table is buillt, if it doesnt work in your table try: Measure2 =FirstSortedValue(current, -sno) . for your understanding i included another epmploee :
@GOKULAKANNAN If your current & Best are direct columns (not measure) then try below with dimension as EmpID
Data:
Load *
Inline [
EmpID, Best,Current
123,48,0
123,48,48
123,48,1
456,35,0
456,35,10
456,35,5 ];
Best = max(Best)
Current = Min({<Current={">0"}>}Current)
