I've got a SharePoint list with the following columns:
- City: eg. London, New York, Milan
- Visit Type: Business, Leisure
- Date: date visited
There could be multiple city visits of the same type, but the dates would be different.
I would like to create a View for this list that shows only the latest Business trips per each location.
So using the sample data above, I would like to see a view that displays this:
I know you can edit the view to show only the rows which are of the "Business" visit type, but I don't know how to group it by City and display only the latest Date.