Hi Guru,
I have a problem for the Macro in DP.
scenario: two key figure. A and B.
cell of B of bucket 11/17 is the sum of cell A of bucket 11/14,11/15, 11/16.
However, next day. the bucket 11/17 of cell B in the macro automatically rolls to 11/18. The reqmt is to prevent the time bucket from rolling for B in the macro. In other words, cell B in bucket 11/17 should never change. It should not be rolling automatically to 11/18. It should always equal to the sum of cell A of bucket 11/14,11/15, 11/16.
I tried many settings in the macro itself. e.g. user-defined, data-dependent, turn on and off of automatically column adjustment from-column, processing area, whole table, one bucket, multiple bucket.
The bucket of 11/14, 11/15, 11/16 for A is not rolling, but B of bucket 11/17 is still rolling.
HELP! Any input will be greatly appreciated.
Thanks,
Hai