Scenario :
In our report we need to populate the data for four seasons, SS09, SS10,SS11,SS12.
The structure of the report will be like:
Season Brand DU Growth% Vol ActualGP
SS09 Adi BB 0 500 0
SS10 Adi BB 0 500 0
SS11 Adi BB 0 500 0
SS12 Adi BB 0 500 0
After applying Growth% of 100 for SS09 the new volume will be 500 + (100*500/100) = 1000.
This volume needs to copied into Vol keyfigure of SS10 i.e Vol of SS10(before applying Growth%) should be equal to vol of SS09.
After applying Growth% on SS10 Vol, that volume needs to copied for SS11 Vol.
After applying Growth% on SS11 Vol, that volume needs to copied for SS12 Vol.
Everytime we enter the Growth Percentage in Growth% keyfigure , That value will transfred to the ActualGP and Growth% keyfigure becomes 0.
Problem:
we are able to copy the data from SS09 to SS10 and SS10 to SS11.
After applying Growth% on SS11 Vol and click on Transfer again SS10 Volume is replaced with SS09 Vol.
But this shouldn't happen.