I have a list that is being used for document control. The list contains multiple items with the same Title as well as other columns. It also contains a manual revision column I would like to display only the record with the highest value for each similar title. (see below)
Default list view:
Title Rev DOC ID
- Item 1 0 123456
- Item 1 1 123456
- Item 1 2 123456
Latest Version View:
Title Rev DOC ID
- Item 1 2 123456
I hope this makes sense?