what is the datatype of object?
if it's string then first convert in the date.
V date=Todate[Date];"MM/dd/yyyy hh:mm:ss a")
Create variable Show/Hide=If ([V date]=Max([V date]) in ([Name])) then "Show" else "Hide"
Apply the filter on SHow/Hide variable.
Hi,
I would sort by type and date in my case and create a variable check to know the unique/first line, add filter on check =1 and I have the required result
Add comment