I believe you will want to tag all of the leaf level
members with the member property and then use this
formula. It will sum all of the members with a member
property of 1 in the "taxes" member property.
SUM({FILTER([Account].[Account Leaf Level].members,
[Account].currentmember.properties("taxes") = "1")},
[Measures].[Cases])
Good Luck
Quote:
-----Original Message-----
Hi to all,
how can I create a member, in the dimension "account",
that is the sum of
all elements (of the same dimension) which
property "taxes" is set to "y"?
thanks in advance
Massimo
. |