Cost centre allocation in power pivot

[Tamtam123]

Hi there,

I’m using the powerpivot to view the expenses by department and I would also like to allocate those expenses from cost centre 1 ( senders) to cost centre A &B ( receivers) So there will be a raw data table with transactions and an allocation table. How can I use the Formula to help me calculate the expenses for cost centre A& B?

Thx in advance!