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'...
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.

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.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Please share the formula for rolling 30 and rolling 60

    • NBOnecall's avatar
      NBOnecall
      Helper V
      6 years ago

      I thought that might be the issue to, but even just selecting avg sale, still doesn't give the average per locationID