Pivot filter allocating by cost centre

[posiwodo]

Hi all - I'm new to the forum so thanks for everything you do to help the Excel community! Usually I get to Excel answers through a quick internet search but for the life of me I cannot get my head around this one...

I have one table with a list of invoices and an allocation of each invoice (in percentages) by cost centre - the percentages will always add up to 100%:

Invoice #	Cost Centre 1	Cost Centre 2	Cost Centre 3
1	20%	45%	35%
2	100%	0%	0%
3	25%	75%	0%

Then in another table I have the amount of each invoice:

Invoice #	Amount ($)
1	100
2	150
3	125

Now I'd really like to have a pivot table with the Invoice # as rows, the Amount as Values and a "Cost Centre" filter. So, for example, I could filter by Cost Centres 1 and 3 only, and the values that would show are:

Invoice #1 = (20% * $100) + (35% * $100) = 55
Invoice #2 = (100% * $150) + (0% * $150) = 150
and so on...

I feel like I either need some form of SUMPRODUCT table that can do a Cost Centre lookup or some form of pivot calculation. I'm relatively comfortable with Pivot Tables and Power Pivot relationships but a real novice when it comes to DAX and VBA so a non-code solution would be ideal if at all possible. Thanks in advance!