Weighted average costs separately against each sub-inventory

Hello Team,

We are in Oracle fusion, R13, 25C.

Need your help and advice on the issue where user would like to change the valuation unit to Sub- inventory level. Currently, we have a valuation structure at the org level only.

Customer wants Weighted average costs separately against each sub-inventory. We are using perpetual avg. cost for 'Asset' type.

Don't want to change the valuation structure to sub-inv level as this required lot of changes and regression testing required which will nnont be fasible, please advie is dere any other method, I tried the below method but can't see the expected details. Please suggest if I miss anything here.