LISTING 2: Percent-of-Total Calculations

WITH member [Product].[Canned Percent] as
  '[Canned Foods] / ([Canned Foods]+[Canned Products])'
  member [Store].[CA Percent] as '[CA]/[USA]'
SELECT { [Canned Foods],[Canned Products],[Canned Percent]} on Columns,
  {[CA],[USA],[CA Percent]} on Rows
FROM Sales
WHERE ([Unit Sales], [1997])