Hi All,
We want to add the future 5 period values of a Key figure and store it in another key figure.
For ex-
The sum of values from M1 to M5 in KF1 ( 10 + 20 +30+40+50 ) needs to be stored in M1 of KF2
Subsequently , M2 to M6 values of KF1 ...
Hi Riyaz,1- Cumulative Aggregation- I have tried but it doesnt work as there is no boundary to stop the aggregation ( like after 5 weeks or 6 weeks)2- Attribute transformation- It is possible through this but it involves creating a lot of intermediat...
