This is an urgent problem, so any help would be greatly appreciated.

I have a ragged dimension that has a property Type against the lowest
2 Levels (level 5 & 6), e.g.

1-All Customers
2--NSW
3---Metro
4-----Sydney
5------CustomerA (Type = "B")
6-------CustomerAA (Type = "B")
6-------CustomerAB (Type = "B")
5------CustomerBB (Type = "A")
5------CustomerCC (Type = "B")
3---Rural

I have another dimension that contains the Types, e.g.
(A Level 3 selection will always be selected for Types.)

1-All Types
2--Group A
3---Type A
3---Type B

How do I create a calculated member that returns the number of
customers of certain Type that exists at the leaf level only. For
example, for Customer A = 2, for Customer AA = 1, for Sydney = 4, etc.

I get stuck on having to specify the level when using Descendants,
e.g.
Count(Filter(Descendants([Customers].CurrentMember,[Customers].[Level
5]),[Customers].Properties("Type") = [Type].CurrentMember.Name))
which means for CustomerA the 1 is returned instead of 2 if Type B is
selected.

Thanks again for the help.

Thanks, I think I've solved it.

Count(Filter(Descendants([Customers].CurrentMember,[Customers].[Level6],
LEAVES),[Customers].Properties("Type") = [Type].CurrentMember.Name))



zelda.calitz (AT) bmw (DOT) com.au (zee) wrote in message news:<c726d6d2.0410202141.6d37a1f1 (AT) posting (DOT) google.com>...