EDMCS Skip ancestor and get first occurrence of the ancestor with property equals Y

Summary:

EDMCS Skip ancestor and get first occurrence of the ancestor with property equals Y, any pointers ?

Content (required):

I am trying to solve a DM problem in EDMCS, any guidance?

Here is the hierarchy

         

        EPBCS_Flag

A123-------Y

  B123------Y 

    Z123 (is base node)

   C123----

     D123 (is base node)

in the DM they want B123 to be the parent of D123 because its direct parent C123 does not have Y for EPBCS_Flag.

Child | Parent

D123 | B123

Z123 | B123

I tried ancestor node property logic to find any ancestor that has a value of Y for EPBCS_Flag but it gets Y not the B123 in the parent