Listing 2: Using a Crossjoin Function to Put Dimensions on Rows
SELECT 
{ [Measures].[Store Sales] }
   ON COLUMNS , 
{ Crossjoin([Time].[Month].Members, Descendants(
   [Product].[All Products], [Product].[Product Name],
   LEAVES))}  ON ROWS
FROM [Sales]