In the Data Model Designer, create a column that will perform a subselect that can be used within a view.