I've got five items one of which I wish to split between the four other
items. However, the fraction allocated to each of the four remaining items
will depend on the relative magnitude of field data for the four items.

i.e splitting overhead costs between the total costs of each product using
machine hours as the basis.

Is this even possible using PivotTables?