WITH

SET [Week]	AS StrToMember("[Date].[Hierarchy - Fiscal].[Fiscal Week].&[2012]&[48]")

SET [Store]	AS {[Financial Transaction Channel].[Transaction Channel Desc].&[POS],
			[Financial Transaction Channel].[Transaction Channel Desc].&[CONCIERGE]}


												
MEMBER [Store Transactions With Returns] AS 	SUM([Week] * [Store], [Measures].[Operational Transactions Count])


SELECT
{
	[Store Transactions With Returns]
} ON COLUMNS,
{
	[Week]
} ON ROWS
FROM EDW

Results: 		Store Transactions With Returns
Wk. 48 - 2012 			78,636

Row Labels	Operational Transactions Count	
Year 2012	          78,368	
  Half 2 - 2012	          78,368	
    Qtr. 4 - 2012	  78,368	
      December - 2012     78,368	
        Wk. 48 - 2012     78,368   Result of addition: 78,636
          1 US STORES     78,368	
             CONCIERGE     3,668	
             POS          74,968	
Grand Total	          78,368	

SELECT
{	[Measures].[Operational Transactions Count]} ON COLUMNS,
{	[Date].[Hierarchy - Fiscal].[Fiscal Week].&[2012]&[48]} ON ROWS
FROM 
(SELECT {[Financial Transaction Channel].[Transaction Channel Desc].&[POS],
			[Financial Transaction Channel].[Transaction Channel Desc].&[CONCIERGE]} ON COLUMNS
	FROM EDW)