Our Goal: To create a filtered table view which only displays unique “product” values. When multiple “product” values exist, only display the record which contains the most recent date/time in column “created on” row.
In the example below, the filtered table view will only display the bottom three records since the first instance of apple in record one will be filtered out due to the date/time in record 4 being most recent.
|Apple||10||12/16/2020 11:50:28 AM|
|Orange||20||12/16/2020 11:50:42 AM|
|Grapes||15||12/16/2020 11:50:58 AM|
|Apple||5||12/16/2020 11:51:08 AM|
Thanks in advance and I appreciate this community!