MDX for Member value for Prior Full Quarter

I am looking for MDX expression that can give me value of a measure for prior full quarter.
I have a measure called [Measures].[Amount] and date hierarchy [Cal YMD] in [Accounting Date] Dimension. And [Cal YMD] hierarchy has the following levels: Calendar Year->Quarter->Month->Date. I am able to get QTD value and Prior QTD value, but I also need value for prior full quarter.

I  wrote the following MDX to calculate, I used LAG() function to get the prior member to the current quarter:

with member [Measures].[PriorQTR] as 'Sum([Accounting Date].[Cal YMD].[Calendar Quater].LAG(1), [Measures].[Amount])'
 SELECT NON EMPTY { [Measures].[PriorQTR] } ON COLUMNS, NON EMPTY { ([Accounting Date].[Cal YMD].[Month Of Calendar Year].ALLMEMBERS ) }  DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [VS 8443 Cube] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

I am getting the below error when I run the above MDX in SQL Server Management Studio:

CellOrdinal 0
VALUE #Error The LAG function expects a member expression for the 0
argument. A level expression was used.
BACK_COLOR (null)
FORE_COLOR (null)
FORMATTED_VALUE #Error The LAG function expects a member expression for the
0 argument. A level expression was used.
FORMAT_STRING (null)
FONT_NAME (null)
FONT_SIZE (null)
FONT_FLAGS (null)

Please suggest me in modifying the MDX to get required results.

-Thanks
Start Free Trial