Revenue Entered in Category level is not properly disaggregating at SKU-ORG level

Summary:

Hello All,

Our client has requirement where they override/Update new Revenue at Category -ORG level.

For eg: If the Revenue for a given Category-org-week is 1000 and if planner changes/update to 1750 for the same then

all the SKU's under that Category must witness an increase in revenue by the same percent from the existing value.

But, that is not happening. When I see the revenue at SKU-ORG level there are some SKU's where the revenue is increased and for some it is decreased.

Can someone let me know how can I achieve this requirement where all the SKU's under the category must witness an increase in revenue from the same % as update at the Category level.