I have two content types lets say A and B. B has a entity reference field which references A. Now I can have multiple contents of type B that references the same content of type A. I have a views that lists fields of Content type A and I have used relationship to show some fields of B which references that particular row. But it shows duplicate entries which is obvious due to the left join. I was wondering is there any way in which I can only show rows of A's fields and B's field in which the B is the latest one. i.e. If there are two instances of B which references A then in the view only show rows in which the values of the one where B is the latest one.
If anyone has done this or has idea on how to do it, i would much appreciate it.
Thanks in advance.