My content type has two fields: field_title and field_related. The field_related is of type Entity Reference and its cardinality is set to unlimited.
The view should display the title, updated date and all related titles, in tabular form, like this:
Title Updated Related
=====================================
Chapter 1 2014-01-01 Note A
Note B
Note C
Chapter 2 2014-02-02 Note A
Note B
Currently, it is displaying this:
Title Updated Related
=====================================
Chapter 1 2014-01-01 Note A
Chapter 1 2014-01-01 Note B
Chapter 1 2014-01-01 Note C
Chapter 2 2014-02-02 Note A
Chapter 2 2014-01-01 Note B
I tried grouping, but it divided the whole table into separate tables.
I see no point here in using aggregation here (maybe I am wrong..)
What is the solution to this?
