LISTING 3: Percent-of-Total Calculations with the SOLVE_ORDER Keyword

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