Aggregation Roll up in my tableau worksheet

Hello All,

Firstly I want to thank the whole group for a great work by responding to each of the queries posted    !

I have a strange situation where one of my measure is rolling upto a strange total. I've just two columns with Group_ID and Amount, joins between these tables is also simple left join. For a group ID 123 there are four amounts 1,2,3,4 and the sum of amount for group Id 4 should be 10, when I mark it as dimension I see all the four entries but when changed to measure it sums up to a strange and unidentical value. Could you please help me resolving this issue.

Thanks in Adv!

Rajesh Musturu