Closed Thread
Results 1 to 2 of 2

How can I link the attached table in powerpivot

  1. #1
    Registered User
    Join Date
    03-09-2016
    Location
    Europe
    MS-Off Ver
    2010
    Posts
    23

    How can I link the attached table in powerpivot

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

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,771

    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:https://www.excelforum.com/excel-charting-and-pivots/1278117-connecting-3-databases-with-powerpivot.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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