SELECT STATE,SUM(STORE_SALES)
FROM table
WHERE product='Good Imported Beer' OR year= 1998 
GROUP BY STATE

WITH
MEMBER Product.mySum AS
'Aggregate (
  Unique ( {
    NonEmptyCrossJoin (
      { Product.[Good Imported Beer] },
      { Time.Year .members}
    )
    +   
    NonEmptyCrossJoin (
      { Product.[Product Name].members },
      { Time.[1998] }
    )
  }), Measures.[Store Sales]
 )'
SELECT
  { Product.mySum } on  0 ,
  Customers.USA.children on  1 
FROM Sales

WITH
MEMBER Measures.mySum AS
'Aggregate (
  Unique ( {
    NonEmptyCrossJoin (
      { Product.[Good Imported Beer] },
      { Time.Year .members}
    )
    +   
    NonEmptyCrossJoin (
      { Product.[Product Name].members },
      { Time.[1998] }
    )
  }), Measures.[Store Sales]
 )'
SELECT
  { Measures.mySum } on  0 ,
  Customers.USA.children on  1 
FROM Sales