Hierarchical table

[#1]

Hi all!!!

I really need your help!

I have the following hierarchical table:

Activity_id	Parent ID	Ancestor id	Depth	name
20391	null	1	0	A
20395	20391	1	1	b
20394	20395	1	2	C
20397	20395	1	2	D
20398	20395	1	2	E
20396	20398	1	3	F

I want to create a pivot table that looks like a tree. I manage to create the Attached table but the 3 level hierarchical isn't working.

I used the 3 following dimension:

1- Ancestor ID

2. if(Depth=2, Parent ID)

3. if(Depth=2, Activity_id)

I don't know how to continue. I try to had the following dimensions : if(Depth=2, Parent ID).... but it's not working.

I really appreciate your help!!!!! thanks.