SUM is not showing correctly

[irenelitw629]

Hi,

I am a beginner and I tried to create a pivot table to show sales name and their respective pipeline ( oppty table) and attainment ( attainment table)

I create a new table to group the sales name and their pipeline - it works.

However when I tried to add the field with attainment data together - the value is off. All the sales have same pipeline number.

Can anyone advice me what should I do? Here is the relationship I created 

[amitchandak · Accepted solution]

The first one is coming from M1. M1 is not joined with other tables. So when you try yo pull in data for other it is showing wrong values.

Please check how these can be joined.