+ Reply to Thread
Results 1 to 1 of 1

PowerPivot Relationship Issue

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    South Dakota
    MS-Off Ver
    MS Office 365
    Posts
    50

    PowerPivot Relationship Issue

    I have two data sets I'm trying to analyze, one has product specific sales data (VB Sales) and the other is leads and accounts pulled from Salesforce that also records if we've done any sales with the account (MasterProspectingData). The common field between the two Datasets is the City with 100K+ population that they fall within a 75 mile radius of.

    I have a separate table that has the unique city list with a relationship field (city/city ID) tied to the city in both datasets.

    I want to create a pivot table that lists all the cities in separate rows and the Firm Name from MasterProspectingData table as well as either FY_to_date_sales and or Prior_FY_Sales from the MasterProspectingData Table. However I also want it to be able to show the total product specific sales from the VBSales table by city. I can't currently get this to work as when I try to include the VBSales numbers it lists every single "firm name" from the MasterProspectingData next to the VB Sales total for that city even though those firms are not present within 75 miles of that city(per the MasterProspectingData table). Is there any way I can get it to show the VB sales total for that city (and ideally the VBSales "Customer Name") as well as the "Firm Names" that are present within 75 miles of those cities?

    I'm attaching a screenshot of the relationship diagram, as well as the issue I run into. Note that if there are no VBSales for the City (Abilene) it displays the proper "firm name," but if there are VB Sales for the city (Akron) it incorrectly displays every single firm.

    Capture.JPG
    Capture2.JPG
    Last edited by kellyjo7; 08-27-2015 at 11:20 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-05-2020, 11:37 AM
  2. Replies: 3
    Last Post: 12-19-2014, 08:12 AM
  3. [SOLVED] PowerPivot Relationship Problem
    By vinaynaran in forum Excel General
    Replies: 2
    Last Post: 12-11-2014, 10:24 AM
  4. Replies: 2
    Last Post: 09-11-2014, 12:08 PM
  5. PowerPivot Relationship Confusion In Excel 2013
    By tomhouy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2014, 03:26 AM
  6. A Powerpivot issue
    By lamtran in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-15-2013, 01:32 AM
  7. PowerPivot many to many date relationship
    By chaserracer83 in forum Excel General
    Replies: 1
    Last Post: 10-08-2012, 03:48 PM

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