Listing 4: Modified MDX Statement That Uses a Calculated Member
WITH MEMBER [Product].[Prod] AS 
   '[Product].[Product Category].[Beer and Wine]'
SELECT 
{ [Measures].[Store Sales],[Measures]
   .[Store Cost] } ON ROWS, 
{ [Product].[Prod] } ON COLUMNS,
NON EMPTY { [Time].[Month].Members }
   ON PAGES
FROM [Sales]