Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

  1. Item 1 0 123456
  2. Item 1 1 123456
  3. Item 1 2 123456

Latest Version View:

Title Rev DOC ID

  1. Item 1 2 123456

I hope this makes sense?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Is simple lines you would need to:

  1. Use filter to show ONLY those titles (or group by Title to get all various "clusters")
  2. Order descendant by the Column for which you Seek the Maximum
  3. Put an Item Limit of 1.

The only question I see open is related to the Clustering (e.g. if you are trying to make the solution reusable). In that situation, i could imagine that some XSLT based conditions in a customized DataForm/XSLTView could work - By example, when calculating groups, in the XSLT there is a condition to check if items are the same. in that place you could use a Variable to compare 2 subsequent items (by using your dedicated column for the Max Version) and the bigger one will be marked visible, while the other no > a sort of bubble-sort!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.