Display Heirarchy Child

Hello Experts,

I have a requirement in BeX where we have a hierarchy. Here we have the parent node - N1, it has 3 childs - N2, N3 and N4. N4 then again have 3 child - N5, N6, N7.

N1

N2

N3

N4

N5

N6

N7

Now I wish to add this in rows in the BeX query and want to display only N4 hierarchy with its child. It should not display the parent node or any other child of the parent. Please help!

Thanks!

Sheen