How to copy the same value to low level when user manually overrides the value at high level

Hi All,

We have a requirement like when user enter the value at high level say monthly level that should get copied to lowest level (weekly bucket). As expected it is happening now.

But the problem here is when new record comes in, the value remains blank only. The requirement is even new records also get populated.

Example1: Current scenario

User enters the value at high level (monthly level) as shown below :

Fiscal month           Values

Jan-14                      10

Feb-14                      20

when we see the same at low level (week level) currently it is showing as below:

Fiscal month        Fiscal week     Values

Jan-14                    W1                  10