Adding this as a big feature request for me. I have a series of spreadsheets and custom code I have use in order to make this happen for me. Would be much better to have it happen automatically.

When implementing this feature, having an "overall price paid" field which automatically distributes it proportionally to the items is important.