Question:
Hi APO Gurus,
I have a requirement from a user, where he wants to change the values for the key figure basing on a set of drill down. But the same key figure is computed by a Macro which is a default macro.
Is there a way or a Macro to achieve this ? Any suggestions would be appreciated
Thanks in advance
kris.
Answer:
I guess you are using the standard workbook. What I would do is make a copy of the standaard workbook and use that one instead. Then goto the macro workbench and change the macro so it does exactly what you want it to do.
Answer:
Hi APO Gurus,
I have a requirement from a user, where he wants to change the values for the key figure basing on a set of drill down. But the same key figure is computed by a Macro which is a default macro.
Is there a way or a Macro to achieve this ? Any suggestions would be appreciated
Thanks in advance
kris.
Hi Kris
There is a standard macro Drill_down (***). Create a collective macro and put the drill down as first step and then next step execute the macro. Put then the collective macro as the default macro.
Best Regards,
Prebne
_________________
Best Regards,
Preben