LISTING 8: Determining Two Top-Selling Products

with member [Measures].[PercTotalSales] as
' Sum( TopCount([Product].CurrentMember.Children,
 2, [Unit Sales]), [Unit Sales] ) 
/([Product].CurrentMember, [Unit Sales])',
FORMAT_STRING = '##.0%'
select [Store].[(All)].Members on COLUMNS,
  Generate( [Product].[Brand Name].Members, 
   Union(
      TopCount( [Product].CurrentMember.Children,
 2, [Unit Sales] ) * {[Unit Sales]},
      { ([Product].CurrentMember, [PercTotalSales]) }
      )
   ) on ROWS
from Sales