Hello everyone,

This will probably be easy to solve for most of you.
I'm using powerpivot to make a moderately difficult cost-model.
The problem I'm running up into is this:
I've loaded a table with the following data:
company, year, month, amount (the total cost booked on the 'cars').
Another table is loaded:
company, year, month, departement, number of cars allocated to that departement in that month.

I would like to have a table with:
company, year, month, departement, euro's to be allocated to the departement for the use of cars.
Where this last amount is:
total amount of euro's allocated for the year and month, divided by the total amount of cars times the number of cars allocated to the particular departement.

Anyone for help?

Thanks

steven