hai all

i am now facing a problem with date range problem
i want to give a date range dynamically for that i have gave it as a member. but it dont gives the previous year member data. my query is here (food mart)

WITH MEMBER [Time].[Condition] AS 'AGGREGATE([Time].[1998].[Q1].[1] : [Time].[1998].[Q1].[2])'
MEMBER [Measures].[Prev Amt] AS '( [Measures].[Amount], Time.PrevMember)'
SELECT { [Measures].[Amount], [Measures].[Prev Amt] } ON COLUMNS,
[Store].[Store State].MEMBERS ON ROWS
FROM Budget
WHERE ([Time].[Condition])

if i gave Time.1998 here, it would give me the correct result

thanx in advance