(Category.&[ACTUAL],ParallelPeriod(Year,1,Time.CurrentMember))*1.1 SELECT { [Time].&[1997] } ON COLUMNS , { [Store].[Store State].&[CA], [Store].[Store State].&[OR], [Store].[Store State].&[WA] } ON ROWS FROM [Budget] WHERE ( [Measures].[Amount] ) SELECT { [Time].[1997] } ON COLUMNS , { [Store].[Store State].[CA], [Store].[Store State].[OR], [Store].[Store State].[WA] } ON ROWS FROM [Budget] WHERE ( [Measures].[Amount] )