Multi-Row formula to calc % of one field of another less granular field

[Carluccio555]

Trying to accomplish the following with a Multi-Row formula (or any method that could be considered the simplest).

How do I generate the Prod%BU column? Each Prod to BU is a 1 to 1 mapping, Each BU % total would add up to 100% as per below.

Thanks

[binuacs]

@Carluccio555 One way of doing this

[Carluccio555]

Hey thanks this is the approach Im currently using, was wondering if using a mutil-row formula was simpler.

[binuacs]

@Carluccio555 @This is the simplest approach, I don’t think multi-row is a right tool to do this calculation.