Question:
Hi chaps,
I am currently coding a macro and I would like to freeze the value at the aggregated level for an absolute value (like for the percentage mode) : In the following example, 13 needs to be locked. If I change the 6 by 2, the 7 will change to 11, in order to keep 13 as total.
13 (locked)
6
7
13 (locked)
2
11
I hope you will be able to help me,
Thanks !
Looping
Answer:
There is provision to tifx the key figure in Interactive Demand Planning, where in if you fix the key figure cell '13' on the aggregate level. And when you change any of the lower level cells, to keep them total -13 as constant, the other lower level values will change. This info is available in sap.help.com for this.
thanks
Harry
Answer:
Looping c'est toi ?
Answer:
Looping,
You can find this funtionality inbuilt using fixing cells in the planning book. This is an alternative solution to using macros.
Check out the following link for detailed info on this.
http://help.sap.com/saphelp_scm41/helpdata/en/8f/9d6937089c2556e10000009b38f889/frameset.htm
Kris