Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: MDX Help with prior 4 quarters

    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]

Viewing post 1 (of 1 total)