Forum Discussion

NBOnecall's avatar
NBOnecall
Helper 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't being broken out by the LocationID. Each one should have its own unique value.

 

Thank you,

Noel

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.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI NBOnecall ,

     

    It is summing up for all your values.

    Right click on the field and hit on "Do not summarize".

     

     

     

     

    Thanks,

    Tejaswi

    • NBOnecall's avatar
      NBOnecall
      Helper V
      6 years ago

      Thank you for the reply, but do not summarize is selected already.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super 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
      Helper 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.