Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Required is the Name of the key with Max date
th Max dat
try this code
This can be one way.
Dimensions: Key & Date
Measure: Aggr(FirstSortedValue(Name,-Date), Key)
Thanks Brun ,
But this didn't solve my query, if I tried this
Firstsortedvalue(Name,-aggr(Date,Key))
I am getting name whose key is having only 1 record, but if there are 2-3 records for that key am not getting any value.
REGARDS.
where do you want this?? in front end or back end??
try this code
Hi Prashant,
I need it back end
Can you help me to achieve this in front end ?
in back end. Logic which I provided in my earlier reply will work.
For Front end what you want to do? From earlier logic remove Left join part and use that max_key_date table for flagging and use that flag in front end
I want to make these Names as default selection with i open the sheet in front end.