Closed Thread
Results 1 to 2 of 2

How can I link the attached table in powerpivot

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    How can I link the attached table in powerpivot


    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?
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 2019

    Re: How can I link the attached table in powerpivot

    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:

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1