Straight Table Seems to Ignore a Dimension

[#1]

Hello Community Folks,

I have a straight table containing the sale units, sale monthname, total sale, and unit open days; The sale unit and unit open days are in the unit table. The sale monthname and total sale is in another table. They linked together by the sale ID

My dimensions are sale units and sale monthname. However, the total sale repeats itself for ALL the sale unit, so it seems that the total sale columns ignores the sale unit dimension. It looks like:

Unit     Sale Month     Total Sale     Unit Open Days

1          Jan                    80               20

1          Feb                    70               18

1          Mar                    95               22

2          Jan                    80               22

2          Feb                    70               18

2          Mar                    95               23

............................................................

So as you can see all the Jan have the same value 80, all the Feb have same value 70, and all the Mar have same value 95, I don't know what happened and caused the problem.

Any idea?

Thank you so much!

[#2]

Post a screen shot of your table structure/script.  It looks like Sale Month is not correctly joined.

[#3]

Thank you Rebecca. It seems the key between the table is not unique. Thank you