Hi,
I am trying to connect 3 databases using powerpivot.
I have invoice spend in which supplier ID is unique (blue tab)
Contracts in which supplier ID can show multiple times (yellow tab) (column "B")
Savings in which supplier ID can show multiple times. (green tab) (column "G")
In the relationship I can only see spend + savings + proposed contract amount. (you can see the powerpivot Output in the tab called Pivot.
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. (When I drag contract expiration date I have strange data)
Can it be done with Powerpivot?
Thanks
Bookmarks