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.
Does anyone have a clue how to solve this?
The ranking should reflect all filters I am using on the report. That's why I did not manage to solve it with RANK_UNIQUE in combination with a LOD expression.
This is not clear. Please elaborate and also post the sample data in text format or with twbx file.