LISTING 6: Determining Brands That Make Up the 
Bottom 20 Percent of Sales

select {[Unit Sales]} on COLUMNS,
 Non Empty BottomPercent([Product].[Brand Name].
Members, 20, [Unit Sales]) on ROWS
from Sales