lag function calculation

  • Hi I have situation

    I am trying to calculate lag period from the present quarter to last quarter

    time hierarchy has

    year(level1)

    quarter(level2)

    i wanted to see percent rejected measure in such a way that

    2007Quarter4 -''percent rejected" shows 2007Quarter3 value

    and

    2007Quarter3 -''percent rejected" shows 2007Quarter2 value

    2007Quarter4 -''percent rejected" shows 2007Quarter3 value

    and

    2007Quarter1 should show -''percent rejected" shows 2006Quarter4 value( I am not able to see these values

    )

    when I gave the above code:

    ( [Time].[TimeHierarchy].CurrentMember.Lag(1), [Measures].[percent rejected] )

    this is fine with year level ,but at quarter level...for example 2008 Q1 is not picking up the value of 2007 Q4

    it shows null values

    when I try this above code

    iif( [Time].[TimeHierarchy].CurrentMember.Level.Ordinal = 2, (([Time].[TimeHierarchy].CurrentMember.Lag(1)),[Measures].[percent rejected] ),

    (([Time].

    [TimeHierarchy].CurrentMember.Lag(1)), [Measures].[percent rejected] ))

    still the same thing happens in the result

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply