LISTING A: MDX Code That Includes an ALL 
OTHER BRAND Record in Each Product Subcategory

IIF((Product.CurrentMember.Level.Name = "Brand Name") AND
 (Product.CurrentMember.Name 
<> "ALL OTHER BRAND"),
IIF(COUNT(CROSSJOIN({[Hidden Store].[Store  
Name].Members},{(Store.CurrentMember,Measures.[Unit 
Sales],Product.CurrentMember.Parent)}),
EXCLUDEEMPTY)>2, Measures.[Unit Sales],NULL),
IIF(Product.CurrentMember.Name = "ALL OTHER BRAND",
SUM( DESCENDANTS(Product.CurrentMember.Parent, Product.[Product Name]) ,
IIF(IIF(COUNT(CROSSJOIN({[Hidden Store].[Store 
Name].Members},{(Store.CurrentMember,Measures.[Unit Sales])}),