Hi,

I am trying to create a calculated measure, but since I am new to MDX, I have no idea how to go about it.

I have two measure groups. One contains the number of customers recruited and is associated with one dimension (Start Week number). The other measure group contains the amount of of sales (¡ê) and has two dimensions (Start Week number + Actual week number).

What I want to do is create a calculated measure of sales amount per customer recruited. The number of recruited customers will obviously be constant for any given start week, and the sales amount will be different for each actual week.

Could anybody advise on a way to do this.

Many thanks,

Dave