Volume Distribution by Region

[shantupm5]

Hi Team

I have below global volumes and the region wise Volume share which is in %.

Please can you help me with the formula for volume disturbution based on % split mentioned ?

[Ritaf1983]

Hi @shantupm5 

If I understand you correctly you can add in PQ column for every category with multiplying it on percentage :

after you will add all necessary splittings, you can delete columns that you don't need:

Result:

These steps are recorded and will complete on every refresh.

Link to the sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly