1 Reply Latest reply on Oct 28, 2018 2:03 AM by Albrecht Kühn

    How can I filter double entries

    Albrecht Kühn



      I have a report which shows a ranked list of TV programs. As you can see below, some of the programs occur several times.

      I would like to show only the first entry of double titles. Therefore I'd like to include a ranking by "starttime" for the partition "title" and set a filter for rank=1.


      The ranking should reflect all filters I am using on the report, e.g. if the first broadcasting is on channel A, but channel A is excluded by a filter, it should not be ranked. That's why I did not manage to solve it with RANK_UNIQUE in combination with a LOD expression as this would rank all entries. To integrate all filters in the LOD expression seems to me complicated as I have filters with multiple values.


      Bildschirmfoto 2018-10-28 um 01.01.37.png


      Does anyone have a clue how to solve this?


      Best regards