Filter or Formula for returning only latest version

I am creating a table from the Table Builder function. In the specific table I am returning the data from there are rows for each archived version of a sales order, I only want to return the last version for each unique order number. In the sample below I only want to pull the data for Version 4 only.

If I try to set a filter on Version No. I only have 'Equal' & 'Between' as options, which doesn't work, I also tried a formula referencing Version No. =Max but I still get all version rows returning? Any ideas welcome thanks.


Please sign in to leave a comment.