It can be solved by creating a Set.
Right click on a [Company] filed, and Create Set...
and select BBB & CCC.
(See [solution 1] sheet in an attached workbook.)
or you can use formula like this.
It just shows the company who has max date of data.
(See [solution 2] sheet in an attached workbook.)
Book1.twbx 21.8 KB
Thanks a million! I was experimenting with sets but not using an LOD in the set itself.