When iam writing calculated measure , i am getting this following
problem, please can u just help me in this. thanks in advance

lets say my product dimension has only 3 members (a,b,c)

Case
when [Product].CurrentMember.Name="A" then [Measures].[Units] * 10
when [Product].CurrentMember.Name="B" then [Measures].[Units] * 5
when [Product].CurrentMember.Name="C" then [Measures] .[Units]* 30
End

But the above code is not showing grand total at bottom

If iam writing like this


Case
when [Product].CurrentMember.Name="A" then [Measures].[Units] * 10
when [Product].CurrentMember.Name="B" then [Measures].[Units] * 5
when [Product].CurrentMember.Name="C" then [Measures].[Units] * 30
Else
SUM(Descendants(Product.CurrentMember,,Leaves),
[Measures].[CaculatedMeasureName])
End
this is showing me correct grand total , but its always shoing grand
total of all members, rather than selected members.

like if i select product A, B then it should give the grant total of
those 2 productrs only but its giving all total,
can you please just tell me where i am wrong