I am not quite sure how to do this. I have content type A and another content type B which references content type A using an entity reference field. So A can have multiple nodes of type B referencing it. Not B has a date field.
Now what I want to do is create a view that lists content of type A but sorted based on the date field of the latest node of type B that references it.
I am not really sure what is the best way to achieve that. Any help is highly appreciated.