Skip to Content
0
Former Member
Sep 22, 2014 at 11:07 AM

drill down option with button

44 Views

Hi,

We have requirement for drill down option ,when i click on the button.

I have entity dimension in the report as rows,when i click on drill down button, the entity should show children of the parent in the report using VBA or any work around.


Entity "abc" has b,e,f .. as children.


In current report


entity time abc 789


when i Click on "drill down"button, the entity dimension member "abc" should show the children of (b,e,f....), as shown below

entity time b 1 e 2 f 3

when I click on "back" button,

entity time abc 789

Please let me know , how to achieve this functionality in the report using VBA or any work around.

Thanks in advance