Listing 2: Query That Finds Which Stores the Top 10 Customers Shop In
WITH
  SET [TopCustomers] AS 'TOPCOUNT( [Customers].[Name].MEMBERS, 10, [Store Sales] )'
SELECT [Time].[1997].CHILDREN ON COLUMNS,
  NON EMPTY CROSSJOIN( [TopCustomers], [Store].[Store Name].MEMBERS ) ON ROWS
FROM Sales
WHERE ([Store Sales])