I have
Packaging_Product_Shop with level packaging, product, shop
Shop_Packaging_Product with level shop, packaging, product
dimension.

When I put in
SUM([Product_Packaging_Shop].CurrentMember.children-[Product_Packaging_Shop].CurrentMember.FirstChild)it works for Product_Packaging_Shop but other dimension, which shared thelevel, screwed up with #Value!. What has happen? What shoud i do to isolate this? IIf staement? Pleasehelp. TQ