I have a measure, "Sales", and two dimensions, "Time" & "Customer". I
would like to create a calculated member called "Existing Customers",
and include all customers in the calculated member who have sales > 0
in [Time].[2003] or [Time].[2004].

I've been struggling with the MDX for this, and would appreciate some
insight on this issue. Thanks.

Ron,

Try something like this -

--This will get a set of customers that have sales in 2004 ans 2005

With

set [CustomerswithSales] as 'filter(descendants([All Customer],0, self),
([2004], [Sales])>0 and ([2005], [Sales])>0)'

-- Use this calculated member to sum (or average) those Customers as a set

member [Customer].[CustSales] as 'sum([CustomerwithSales])', solve_order=1

HTH,

Jim


"ron.brooks (AT) csgpro (DOT) com" wrote: