Relationship Issue

[NBOnecall]

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

[Ashish_Mathur · Accepted solution]

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]

@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]

Good to hear that.

[Anonymous]

HI @NBOnecall ,

It is summing up for all your values.

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

Thanks,

Tejaswi

[NBOnecall]

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

[amitchandak]

Please share the formula for rolling 30 and rolling 60

[NBOnecall]

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