hi, this mdx query is wery slow in excel
iif(Isleaf([Product].CurrentMember),
([Vendor].[Vendor].&[],[Measures].[Sales Price]),
SUM(Descendants([Product].CurrentMember,,Leaves),
([Vendor].[Vendor].&[],[Measures].[Sales Price])
))
I'm trying to calc the right sum for the Product groups for current Vendor,
the Dimension "Poduct" has 4 levels.
For all the levels in Product I have to calc the leaves in Product Dimension

Please Help me..