Here is how my cube looks like:

--------------- Sales ----- Returns ----- Net Sales
Curr. Year 30 10 20
Prev. Year 34 12 22
Change -4 -2 -2
Change % -12 -17 5

Problem lies in the bottom left cell, "Change %" for "Net
Sales"

It shows 5 (minus 12 less minus 17) instead of -9 (minus 2
divided by 22) because the solve order is wrong.

The "Change %" is defined as a member of the Time
dimension, and the "custom member formula" is: iif
(CoalesceEmpty([Time].[Year].[Previous], 0) = 0, null,
[Time].[Year].[Change]*100 / [Time].[Year].[Previous] )

The "Net Sales" measure is a "calculated member", with the
value defined as [Sales] - [Returns]

I need the "Change %" to overwrite the "Net Sales"
calculation, but I cannot figure out what to do to make
the "custom member formula" solve after the "calculated
member".

Any ideas?

Thanks in advance.

In order to assign solve order to a custom member (versus a calc member) you
must use so-called "custom member options", a column in the dim table that
let's you store the various properties that can be assigned to calculated
members.

tom @ the domain below
www.tomchester.net


"James" <news (AT) att (DOT) com> wrote

Brilliant! Many, many thanks.