In order to prevent a list view threshold issue I would like to have a list filtered by the last 5000 records. It would be something like Select Top 5000 order by ID Descending. Tried to implement a filter level like below but apparently only accepts [Me] and [Today] as dynamic fields. Any suggestions to achieve this?
Your support is really appreciated.