Display manager and employees' phone numbers on a single row in OTBI analysis report

Hi

I try to display the manager and employees' phone numbers and email on a single row in otbi analysis table, but without any success.

For the employee, I use this formula:

MAX(CASE WHEN "Person Phones"."Phone Type Code" = 'WM'
THEN "Person Phones"."Area Code" || '-' || "Person Phones"."Phone Number"
WHEN "Person Phones"."Phone Type Code" = 'HM'
THEN "Person Phones"."Area Code" || '-' || "Person Phones"."Phone Number"
ELSE NULL
END
BY "Worker"."Person Number")

It's working, but I can't get the Manager's phone information using this formula:

MAX(CASE WHEN "Workforce Management - Person Real Time"."Person Phones"."Phone Type Code" = 'WM'