Viewing post 1 (of 1 total)
I think this query should return sales for prior 4 quarters:
SELECT
NON EMPTY { [Measures].[Net Sales] } ON COLUMNS,
NON EMPTY { ([Calendar].[Quarter].currentmember.lag(4):[Calendar].[Quarter].currentmember.lag(1)) } ON ROWS
FROM [Marketing]
April 19, 2011 at 8:59 am
#1313421