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?
My understanding is that you are trying to get unique user names for a specific department to build a list.
I think you can build a filter module to input which department you want to export the unique names from. Use the input to filter the module where you have the user name. You might need to create a Boolean line item to check whether the department in this module is the same as the one in the filter module. Doing this, you might not be able to automate the build of the list as it depends on the selection in the filter module.
@ChrisHeathcote@andre.lie Thanks a lot, really appreciate your advices. I'm still trying to work on it. The challenge is to get unique list from a list formatted line item which has multiple dimensions. Had also tried to build an independent module by using FIND argument, it didn't work yet. Will keep you posted if any results.