Problem when filtring on OTBI to take MAX(date) for many user
SummaryI want to filter for max(date) for many users , It works only for one user .
I create a report to display person id with a item_text,but for each item_date we can have 1 or more occurence and we can detect it by the field date_from .
I want to take only the last occurence so I create a filter on MAX (date) where person number ='aaaa'.
The result is correct but in my reports I have 300 person number and I can't make person_number in ('aaa','bbb','ccc','dddd'............)
the filters That I insert for the date from is :