3 Level Hierarchy Problem - Data Available till 2 Levels

[Pulkit_Thukral]

All,

Working on a requirement to showcase 3 Levels of hierarchy- Parent,Children, Grandchildren

Data - I am receiving 2 Fields in the Data - Parent ,Child

Problem - To show 3 Levels of Hierarchy, First 2 level can directly be shown from the data. But, for 3rd Level we need to consider Child from 2nd Generation as Parent for 3rd Generation and find its children.

Example-

Parent	Child
A	D
A	E
A	H
B	I
C	K
D	M
D	N
E	Z

If user selects Parent value- 'A'

Then a Pivot chart should be generated with below values

Parent	Child	Grandchild
A	D	M
		N
	E	Z
	H

Please help in achieving it.

Thanks,

Pulkit Thukral

[kfoudhaily]

check this link: Creating Cycle and Drill Groups

[Pulkit_Thukral]

Kh fou,

Link from your mail defines Cyclic and Drill down properties. I am dealing with the back end data rather than Front end changes.

Thanks