SELECT 
  NEST({Smith, Jones}, {USA_East.Children, USA_West, Canada}) 
       ON COLUMNS, 
  {1995Q1.Children, 1995Q2, 1995Q3, 1995Q4.Children} ON ROWS
FROM SalesCube
WHERE (Sales, Pizzas)