Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check this link: Creating Cycle and Drill Groups
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