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.
I appreciate the help.