June MDX Puzzle - 01 Jun 2001

The June puzzle doesn’t relate to calculated cells but is a common problem for companies that gather retail market data. These organizations need to show the leaders, typically for brands, and to show that information relative to the rest of the brands. If you can solve this puzzle, you can access such information. Using the FoodMart 2000 Sales cube, show the top products (at the product department level) that make up 80 percent of unit sales, then group the rest of the products in one sibling member labeled Other.