I have a list with a "category" column (a lookup), there's potentially hundreds of items in the list with multiple entries per category. I need to filter the view to only show the most recently modified entry per category.
So let's say the entries for category A were modified on 1st June, 5th June, 12th June, and the entries for Category B were modified on 3rd May, 10th May and 27th May, I would want my filter to show the entry for Category A modified 12th June and the entry for Category B on 27th May.
I'd tried using an item limit but this limit is for the overall list, not on a per category basis (or I should say per group basis as I attempted this with group by set to group by category).
So if I have 100 different categories assigned to different list items, I need all 100 on one page as users will probably further filter the columns on an ad hoc basis as they use this list.
I have other filters in place that ensure the view will never exceed 5000 items.
I'm using SharePoint 2013 and working with a custom list. I'm hoping to find a solution using OOTB functionality or using SharePoint Designer (including workflows).