Use Item as dimension, the expression max(Date) to find the maximum date and the expression firstsortedvalue(Value, -Date) to find the value corresponding with the maximum date. Note, Date should be a field with real date values. If the field contains string values then you'll have to create dates from them first in the script: date#(Date, 'MM/DD/YYYY') as Date. Or maybe you need DD/MM/YYYY as date format. I can't tell from your data.
Use Item as dimension, the expression max(Date) to find the maximum date and the expression firstsortedvalue(Value, -Date) to find the value corresponding with the maximum date. Note, Date should be a field with real date values. If the field contains string values then you'll have to create dates from them first in the script: date#(Date, 'MM/DD/YYYY') as Date. Or maybe you need DD/MM/YYYY as date format. I can't tell from your data.
