- Module dimension: Department, Country
- Line item: User Name. (Formatted with a fake User List)
I'd like to get all unique User Names from a specific Department 'ABC' and ALL Countries, with these unique user names, I'll able to build a list.
I tried to create a subsidiary view in the module, dimensioned with fake User List, the new line item formatted Boolean called IsFirst?=isfirstoccurrence(User Name [Select: Department.ABC], fake User List)
However the result is not correct, all value is FALSE.
I also tried to use system Users instead of fake User List for the ISFIRSTOCCURRENCE, the feedback was Invalid use of 'Users' list with function 'ISFIRSTOCCURRENCE'
Given ranges, Do we have any formula in Anaplan allowing to directly retrieve all unique items from a specific line item. Is there anyother way to solve the problem?
Thanks in advance!