In the cube script (or in the query) you ll need to create a calculated measure with a CASE statement to to apply the logic you need to.

If the...