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.

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
Icon for Helper V rankHelper V
6 years ago

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