I have a target metric wherein I need to fetch all the project names assigned to a person within 12 months.
E.g. If the same project exists for multiple months in the source metric, in the target metric - it should return only the unique ones.
I tried this formula, this is working fine and returning all the projects assigned to each person in all the months.
But I want to fetch the unique projects.
Source Metric has dimensions: project, role, month
Target metric has dimensions: Project, role.
'Project Assigned'.Name[BY TEXTLIST: 'd. Month'][REMOVE TEXTLIST: 'd. Month']
