I've created a report using table builder. I've linked 4 separate tables, one of which returns the posting date of the purchase receipt line table. When I run the report, it returns the "first" (or oldest) record which goes back to 2014 for one particular item. Does anyone know if there's a way to get it to return the "last" (or newest) record from 2023? I know I could easily use an NL function normally, but I can't seem to get that to work correctly with the builder.
Return "Last" record while using table builder