Where clause

[simpilla]

Hi
I am running a

SELECT{[Measures].[Store Sales]} ON COLUMNS, Product.[Product Family].MEMBERS ON ROWS FROM Sales
WHERE ([Store].[WA])

It works fine.
Now I want to add [Store].[CA].

SELECT{[Measures].[Store Sales]} ON COLUMNS, Product.[Product Family].MEMBERS ON ROWS FROM Sales
WHERE ([Store].[WA],[Store].[CA])
then i got Unable to open set error.
Please correct me



Thanks
Sim

 

[unclejimbob]

WITH MEMBER [Store].[Both] AS 'Sum({Store.[WA],Store.[CA]})'
SELECT{[Measures].[Store Sales]} ON COLUMNS, Product.[Product Family].MEMBERS ON ROWS FROM Sales
WHERE ([Store].[Both])

I'm sure there is a more elegant solution than this - so pipe up if you have one