Filter Column Data with other Columns?

Nov 5, 2020 10:28PM

Summary

Issue at the moment of filter column X with data of column Y

Hi everyone!

I'm working on an analysis and I have the following information:

1. Column A with all phone types of an employee. It can be filtered by "Home phone", "work phone", and so on.

2. Column B with all the phone numbers of an employee.

I'm trying to show in column B only the "home phone" of the employee by using this filter in the Edit Column Formula:

FILTER("Person Phones"."Search Phone Number". USING (DESCRIPTOR_IDOF("Workforce Management - Person Real Time"."Person Phones"."Phone Type") = 'H1'))