Need help with creating a macro for the following :
Planning book/ data view:
Macro should drill down at product level and when ever the product is “100” it should do the following calculation:
Sales of Product ( 100) for Wk1 + Sales of Product (102) for wk1= 30
Find % difference for product 100 for wk1 with the total = (10/30) *100= 33.3
Generate alert if the % difference is NOT between 40 and 50. This should be done in same way for other weeks. Calculation is only required when the product is “100” in drill down.
I can use DRILL_DOWN( 'product' ) for drill down. I not sure what functions can be used for the calculation.