Filtering items in SharePoint list view

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.

Sample Data:

City Visit Type Date
London Business 2021-01-15
Paris Leisure 2020-12-30
London Business 2020-08-10
London Leisure 2020-07-06
New York Business 2019-06-05

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:

City Visit Type Date
London Business 2021-01-15
New York Business 2019-06-05

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.