Hi,

I am new to MDX and cannot figure out how to create a particular calculated member (call it AmtScore). The data looks something like this:

Customer.......Account......Amount.....WeightingFa ctor
1..................1................ ...........1
1..................2...............$1000.........2
1..................3...............$2000.........0 .25

I want to create AmtScore by multiplying: [Amount] X [Weighting Factor]. But, I don't want the total for a customer to be [the sum of Amount] X [the sum of WeightingFactor]. I want it to be the sum of AmtScore.

No matter what I try, customer 1 ends up with an AmtScore = 9,750 ($3000 X 3.25), when I need it to be 2,500: (blank)*(1) = 0 + (1000) * (2) = 2000 + (2000)*(0.25) = 500.

Any help would be greatly appreciated. Thanks,

Chris