LISTING 5: Determining Brands That Make Up 80 Percent of Sales

select {[Unit Sales]} on COLUMNS,
TopPercent([Product].[Brand Name].Members, 80,
 [Unit Sales]) on ROWS
from Sales