Hi,

does it possible to setup the non empty behavior option of a calculated
member regarding specific positions in the cube?

I have a formula like:
measures.NYSales = (measures.sales, country.city.NY)
(in reality my formula is more complex, but the idea is the same)

so the result is empty when I'm not on the NY city.
but my Excel users will see empty (null value) cells for other cities.
and the non empty option in the select statement don't hide these cities
because they are not empty.

select non empty country.city.members on 1,
measures.NYSales on 0
from sales

display all cities not only NY.

so, how can I setup a non empty behavior option for the specific sales AND
NY position only and not based on the sales measure only???
remember, my users use Excel, so there is no ad-hoc MDX query, only the
pivottable...

thanks.

Jerome.