Filter by max number

Hello,

For a simple example of what I’m trying to accomplish, let’s say I have a table with the following values:

tblDrawings
image

How can I filter that list to show only the maximum rev of each item in the list?

image

I’ve tried several ways and functions but I can’t get it to work.

Thanks for any help provided.

Hi there, @gnelson… if I understand your post correctly, use the :group by operator and give this setup a shot.

The text element in the repeating group to show the max revision would look like this.

max

Hope this helps.

Best…
Mike

1 Like

Got it. and thank you! I should have know that but been away from here for almost a year. Guess I’m getting forgetful in my old age. :wink:

1 Like