Mapping issue - only populate Manager that is from that Department
I'm wondering how to only get the name of a person who is part of a department in a module that has department as one if the dimensions.
SYSTEM Module for Users:
Line Item: Departments (List-format with department which is populated based on a formula using the lookup function).
Dimensions: Users, Department
Line Item: Manager in Department (List-formatted with Manager list)
So I only want the line item in the mapping module to populate a manager if he is part of that department, else blank.