Forum Discussion

NBOnecall's avatar
NBOnecall
Icon for Helper V rankHelper V
6 years ago
Solved

Relationship Issue

Hi I have the following relationships active in my workbook. I am using Internal ID as the primary key.   I do not understand why the Average of SalesAmount and Averag of Rolling 30 days isn'...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Create a 4th Table called LocationID and then build a relationship from the LocastionID of the 2 Tables to the LocationID of this new table.  To your visual, drag LocationID from the new table.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Create a 4th Table called LocationID and then build a relationship from the LocastionID of the 2 Tables to the LocationID of this new table.  To your visual, drag LocationID from the new table.

Hope this helps.

NBOnecall's avatar
NBOnecall
Icon for Helper V rankHelper V
6 years ago

Ashish_MathurThis did the trick. I swear I tried to do this earlier, but a conflict was found with a different table. Nevertheless I am happy to get it resolved.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Good to hear that.