Need help regarding a three dimensional table!

[Intekhab]

Hi,

I have a situation whereby I seem to need a three dimensional table in EXCEL. Can someone help me with the following problem?

I have to divide the costs of 14 cost centers over 5 different entities each period and I am not being able to make a table or a format which would allow me to do it efficiently as well as correctly.

To elaborate, I have developed a detailed model where after some calculations the relevant costs are collected for 14 Cost centers via a pivot table. Now I have to find a way to divide the costs(amounts) of each of the cost centers over 5 different entities based on a fixed percentage every month. Can someone help me with this?


Thanks in advance.

Regards,

[dflak]

I would help a lot if you could include a sample workbook with source data. Change the data so nothing sensitive is posted. Are your three dimensions cost center, the entities in the cost center and month?