I have a SharePoint list that has several records. One field in the list uses SPServices to query possible values in another list during data entry (essentially a lookup).

I created a view and am looking at customizing the XSLT so that I only show records where the lookup field mentioned above appears more than once. For example, say I have a simple list:

ID Location
===============
1 123
2 123
3 456

I want to create a view where the only items that are displayed are ID#1 and #2 because the location appears multiple times.

If a new item (#4) is added and it contains a location of 123, #4 should now appear in this view, but #3 should still be excluded.

ID Location
===============
1 123
2 123
3 456
4 123

Instead, if #4 had a location of 456, all entries should display (preferrably grouped) in the view.

ID Location
===============
1 123
2 123
3 456
4 456

So I am assuming that 1) I need to do a count for each location, 2) assign a count for each entry in the list and 3) filter on the count field where greater than one. I am just not sure where to start here.

Could you include the XSLT that you have written so far? Thanks!
–
Marcus RickertNov 2 '13 at 1:17

I'm a little confused since the code that you mentioned is not valid XSLT or XPath.
–
Marcus RickertNov 7 '13 at 9:18

I added Conditional Formatting on the row, which hides the rows succesfully. But I would also like to hide the header as well. The condition I am using is the following: CONDITION: count(/dsQueryResponse/Rows/Row[@Location1=$thisNode/@Location1])<2 FORMATTING: Display:None
–
JuanTrevNov 7 '13 at 21:00