PivotTable Help
 

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?

Can you give an example of the type of data you have and what you want?

"G" wrote:

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?

Sure,

I've got currently got a PivotTable set up with the page field = financial
year, row field = client, and column field = activity. The possible data
fields are Gross Income, Labour Hours, Costs.

However the costs of one activity (the overheads) must be split between all
the others: new cost = old cost + overhead cost * labour hours / total labour
hours

"Barb R." wrote:

Can you give an example of the type of data you have and what you want?

"G" wrote:

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?

OK, so you have data in columns in

FINANCIAL YEAR
CLIENT
ACTIVITY (including OVERHEAD + 4 other items)
Gross Income
Labour Hours
Costs

I'm not sure you can do what you want with PIVOT Tables alone. I'm
guessing you'll have to manipulate the results of the PIVOT tables to get
what you want. Maybe someone else can help.
"G" wrote:

Sure,

I've got currently got a PivotTable set up with the page field = financial
year, row field = client, and column field = activity. The possible data
fields are Gross Income, Labour Hours, Costs.

However the costs of one activity (the overheads) must be split between all
the others: new cost = old cost + overhead cost * labour hours / total labour
hours

"Barb R." wrote:

Can you give an example of the type of data you have and what you want?

"G" wrote:

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?