Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Drill down group - Year,Half Year,Quarter,Month and Week.
When I click a button the chart should be shown at Quarter level and it should have the drill up and drill down functionality. Is it possible?
Hi,
click on a bar (in a bar chart) and "drill down" is in place.
Click on the button and you will "drill up".
Good luck!
Rainer
When I Click a button the drill down Group level should be changed to Quarter...Please refer the attached file
Hi,
I would prefere a "Cyclic Group" instead of a BUTTON and a TRIGGER or MACRO.
Right click on Cyclic icon and choose the dimension you need.
Rainer
Thanks for your reply.
Is it possible to set the drill down group always at level1 when I open that particular sheet rather than the last selected level?
Hi,
maybe an ACTION and "Clear All" is an option.
See the screenshot.
Rainer