Return "Last" record while using table builder

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.


Please sign in to leave a comment.