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
when i Click on "drill down"button, the entity dimension member "abc" should show the children of (b,e,f....), as shown belowentity 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