How can I link the attached table in powerpivot

**paxonltd** · 06-07-2019, 06:18 AM

Hi,

I am trying to coonect 3 databases using powerpivot.

I have supplier spend in which supplier ID is unique (see "blue tab")

Contarcts in which supplier ID can be repeted multiple times (see "yellow tab"

Savings in which supplier ID can be repeated multiple times. (see "green tab")

The only correct value i can see is: "supplier spend" and "proposed contract amount". The savings Output is not working

I have tried to add a table called category (which is unique) to link the contrract with the savigns but again I am not able to link all the 3 tables.

I have added a tab called "desired Output" in which I would like to see the supplier spend + savings + proposed contract spend + contract expiration date.

can it be done with Powerpivot?
Thanks

**alansidman** · 06-07-2019, 08:04 AM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread:https://www.excelforum.com/excel-charting-and-pivots/1278117-connecting-3-databases-with-powerpivot.html