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,