Views Fields and Relationship with Aggregation I have three content types :
Content type A (= leg)
Content type B (= transport)
Content type C (= ticket) 

B has a node reference to A.
C has a node reference to B.  

I have a views list with the following and aggregation setting is on;


  
    FIELDS
    Content: Nid
    Content: From
    Content: To
    (field_transport) MIN(Content: Price) (for)
    (term from field_transport_type) Taxonomy term: Name (by)  
    
    FILTER CRITERIA
    Content: Published (Yes)
    Content: Type (= Leg)
    Content: From (exposed)
    Content: To (exposed)  
    
    SORT CRITERIA
    Content: Post date (desc)  
    
    RELATIONSHIP
    (field_transport) Content: Leg (field_leg) - reverse
    (field_leg) Content: Transport (field_transport) - reverse
    (field_leg) Content: Transport Type
    (term from field_transport_type) Taxonomy term: Content using Transport Type   
  


The result with 3 records is shown as below :  


  
    RESULT
    How to go from Bangkok to Singapore:
    for $150.00
    by Plane  
    
    How to go from Bangkok to Singapore:
    for $200.00
    by Train  
    
    How to go from Bangkok to Singapore:
    for $80.00
    by Bus  
  


I want the result with the only last line ( for $80.00 by Bus ). The result is correct before I have no relationship with term from field_transport_type.
How can I do that with aggregation setting MIN which I already applied in the field list?
I'm using drupal 7.10.

[Edit]
Here is the screen cast of my view :


Another thing is that the content type B (=transport) has a taxonomy term field (=transport type) which needs to be displayed in the field list. You can see them in the result - by Bus, by Plane, etc.

To be more clear, I attached another screen cast of my results :

The result should be 2 records above. The last three lines is the group of a leg ( Bangkok to Singpore ). This cannot be done by changing the pager settings. Pager is 10 for the page, meaning - latest 10 legs with cheapest tickets.

[Edit]
When I changed field_transport_type in FIELDS into COUNT(DISTINCT Taxonomy term: Name),
I got the result with the first two lines, but I lost the transport type names. 


  
    How to go from New York to London: for $120.00 by 1
    How to go from Bangkok to Singapore: for $80.00 by 3
Perhaps you want to remove the post date sort criteria, and add an ascending sort criteria for content: price. If you only want one result value, change that in the Pager area.