+ Reply to Thread
Results 1 to 4 of 4

Keep getting "Relationship between table might be required" and how to Add measurement?

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    422

    Keep getting "Relationship between table might be required" and how to Add measurement?

    Hi, i have 3 table. Pdt, Sales and Salesman. Pdt and Sales is link via Product Code while Sales and Salesman is link via Invoice Number.

    I have done up the relationship, however, i keep getting all the Same value when i drag Salesman's item in my pivot table and also keep getting the "Relationship between tables may be required" message.

    Also, i would like to add measurement for Qty * Sales Unit Price to have a Total Sales.

    Would appreciate if someone can enlighten me.

    Please refer to attached for more information.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    4,713

    Re: Keep getting "Relationship between table might be required" and how to Add measurement

    You don't need to use Pdt since that number is already on each invoice. You need to add a calculated column to the Sales Info table in the model that multiplies the Qty by the Unit price (I'm assuming that in real life you will have more than one product per invoice).
    Rory
    Yea though I walk through the valley of the shadow of death, at least it's a change of scenery

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    422
    Quote Originally Posted by rorya View Post
    You don't need to use Pdt since that number is already on each invoice. You need to add a calculated column to the Sales Info table in the model that multiplies the Qty by the Unit price (I'm assuming that in real life you will have more than one product per invoice).
    Hi, becoz that Pdt table has the Cost of the product. Hence need it to compute the Gross Profit of the sales. Do u mind attaching one sample?

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    4,713

    Re: Keep getting "Relationship between table might be required" and how to Add measurement

    It wouldn't work for you as I have 2016 and the data model is not backwards compatible with 2010's PP add-in.

+ 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. [SOLVED] Need assistance with "Pivot Table", "Slicer", and "Dynamic/Interactive Graph"
    By skydivetom in forum Excel Charting & Pivots
    Replies: 26
    Last Post: 06-27-2020, 11:03 AM
  2. Replies: 7
    Last Post: 06-27-2020, 05:02 AM
  3. "Object required" error upon "Exit Function" statement
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2018, 06:40 PM
  4. [SOLVED] "ActiveWorkbook.Path" fails - triggers "Compile Error Object required"
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-15-2018, 02:58 PM
  5. [SOLVED] "ByRef:mismatch" and "Constant Expression Required" Errors
    By Mishil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-10-2015, 06:47 PM
  6. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  7. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM

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