Hi All,
Hope All is well.
I have a requirement and trying to work on it for a couple of days and haven't arrived at a solution.
Basically I have a report where in its divided in to 2 sections. (Section 1 is easy. Struggling to get Section 2 working as per requirement).
Section 1: 2 Charts with a measure each , 2 Crosstab reports with a measure each. It will Drill Up and down based on Hierarchy Structure.
Hierarchy Structure: Division(Level 1) --> Branch(Level 2)--> District(Level 3) --> Region(Level 4) -> Area(Level 5) etc.
Section 2: Should be able to able to show hierarchy Structure (level wise) as I drill up and down the charts in Section 1.
For ex:
If I drill down on Division in charts Section 1, It should show Level Names as below in Section 2
Division --> Branch
If I drill down on Branch in charts Section 1, It should show as below in Section 2
Division --> Branch --> District.
Also if I click any Level it should drill up in Section 2.
Is this achievable?
Please let me know
Thanks in advance
Regards
Geetha
Hi All,
Please anyone has any idea on how to achieve drill up and down on the data items?
Please advise
Thanks in advance
Regards
Geetha
not sure if it is doable.
the best thing i can think off top of my head is section 2 should be a drill through report.
What happens if you point your Section 2 Layout object (say List) to the same query as your Charts from the Section 1.
Does it change when you drill in the Charts?